A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Advanced Filtering by Kirk P.
Is it possible to set up advanced filtering showing records where an amount is, say = 2 AND = 4?
November 19th, 2009 06:26 PM
by Peo Sjoblom[_3_] Go to last post
2 76
Create a flat file in Excel by GF08
I need to create a flat file in Excel using the pipe delimiter | as element, and carriage return line feed as line delimiter. How do I do this?
November 19th, 2009 06:10 PM
by Jacob Skaria Go to last post
4 103
=today() less one month by Jim
Hello, In a cell I would like to return last month, October. What is the formula for this? Thanks Jim
November 19th, 2009 05:43 PM
by David Biddulph Go to last post
4 132
change cells contents from vertical to horizontal by GailH
I need to copy from one workseet the values in cells that are arranged vertically into another worksheet and the values need to be arranged horizontally. Can...
November 19th, 2009 05:41 PM
by GailH Go to last post
2 106
Yes no drop down list and macros by Larry Fitch
I have an excel sheet that get imported into another workbook by way of a macro.. This sheet contains two drop down lists. When I run the macro I get an info...
November 19th, 2009 05:40 PM
by Jacob Skaria Go to last post
4 125
how to count the number of times text occurs based on condition by Liv[_2_]
scenario: i would like to return two numbers, the count of times each fruit occurs when 5 and =5, and the sum of the value when each fruit is 5 and...
November 19th, 2009 05:38 PM
by David Biddulph Go to last post
3 108
formula to make currency formatting useful by Nipsey Russell
situation: a woman i work with pays thousands of invoices a year and records them in a spreadsheet. When they are in different currencies, she doesn't...
November 19th, 2009 05:37 PM
by Nipsey Russell Go to last post
4 121
Transfer data from an excel tab to a pivot table automatically by GKelly
Hi, I have data the generates into excel sheet from a CRM platform. I want the data that gets exported onto this excel tab to automatically generate into a...
November 19th, 2009 05:35 PM
by GKelly Go to last post
0 88
Length of an Excel document by suroora
Is there a maximum length for an Excel spreadsheet before it crashes? My colleague has one that goes into several sheets, and she was worried it would crash...
November 19th, 2009 05:33 PM
by suroora Go to last post
3 112
Pivot table missing column by Pivot Table missing column
Hi, I need help here on Pivot table. I run the pivot table on a big report with 12 months display, I always missing one month data and don't know why's that....
November 19th, 2009 04:38 PM
by Pivot Table missing column Go to last post
0 91
Hyperlinks were lost by Etz99
Hi All, I have Microsoft Office 2007 and I have a spreadsheet that contains hundreds of links to forms to each individual row created. I last saved my file...
November 19th, 2009 04:32 PM
by John Keith Go to last post
3 143
vba code by CandiC
does anyone know if it is possible to write a macro to clear all unlocked cells by the click of a button on a user form?
November 19th, 2009 04:04 PM
by CandiC Go to last post
4 124
Macro with line graph by Sasikiran
Dear, I have huge data with different headers. I want to plot a single line graph linked with a validation with the list of all the headers. The data in the...
November 19th, 2009 03:13 PM
by Don Guillett Go to last post
2 129
how to unlock a sheet without password by nakama
i have problem to unlock an excel sheet because i have forgot my password, can you provide me the advisable guildlines?
November 19th, 2009 03:02 PM
by John Go to last post
2 100
Formula For Multiple Rows by satrntgr
In Excel 2009 I need to multiply rows 1 through 55 by $0.35. I don't need any amounts of the rows multiplied by that, just the number of rows (55 x $.035). ...
November 19th, 2009 02:47 PM
by Bob I Go to last post
2 101
"Centre Across Selection" and character limit by upsidedown_pw[_2_]
The problem I have been having is when I type text into a cell it limits me to displaying over 255 characters and instead displays #### Following advise, I...
November 19th, 2009 02:34 PM
by Dave Peterson Go to last post
1 99
Date format getting muddled by Jez
Hi, I work for a computer software company. We export data to Excel. We have a client in South Africa where the date is getting muddled when it is exported...
November 19th, 2009 02:34 PM
by Dave Peterson Go to last post
3 146
Access or Macro by dab
Good day Thanks for reading. I need to create a user interface that will allow the user to input some values and then the program/macro will use this...
November 19th, 2009 02:15 PM
by dab Go to last post
2 107
Pivot table help? by Scott
Hi I've got a list of job numbers in column a, with a list of hours worked in column b. There are a number of repeating jobs in column a as some jobs have...
November 19th, 2009 01:58 PM
by Eduardo Go to last post
1 109
-sign by bbc1
I have5 columns a b c d e I would like a formula to work out and show a minus sign if the total of cell d is greater than the total of cell a, if cell d is...
November 19th, 2009 01:45 PM
by Jacob Skaria Go to last post
2 89
Post New Thread


Display Options
Showing threads 9761 to 9780 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.