The whole page moves with the up/down arrows, not the cells
Sat, 20 Mar 2010 16:20:01 -0700
How do I stop the whole page from moving with up/down arrows? I just need to
change the cell. Excel 7 ...
|
Email pivot table report page.
Sat, 20 Mar 2010 16:13:02 -0700
Is it possible to email only one page from my pivot table? Say I have a
report on sales rep as page field and I want to email only his page to him.
Is it possible to email that page to the respective sale rep? ...
|
How can I rotate an XL worksheet 180 degrees
Sat, 20 Mar 2010 14:37:01 -0700
I have turned a worksheet into a graph page and need to rotate it 180 degrees. ...
|
bins, frequency function
Sat, 20 Mar 2010 14:36:01 -0700
when i select the data and bins array and press CTRL+SHIFT+ENTER some number
appear in the column but they are incorrect and the last number of cells in
the column just say NAME?
Please could anyone help me? ...
|
#VALUE!
Sat, 20 Mar 2010 13:43:01 -0700
When a cell returns the text #VALUE!, how can I convert this to read the
number 0? ...
|
Export range to text file
Sat, 20 Mar 2010 13:41:02 -0700
I need to export a range from excel to a text file with a delimiter such as a
comma or semicolon. I want to be able to have some kind of macro that will
check each row and if a row is blank then it will stop there and only export
the rows that has data. Which is why I was thinking of using a range, or
arra ...
|
Help for the formula
Sat, 20 Mar 2010 13:10:01 -0700
Dear All,
Please i need the formula for colum D Status, it can display Pickcal or In
or Out or Picked.
Colum A Colum B Colum C Colum D
Confirm Date scanin scanout Status
...
|
|
|
Opening xlsx files in Excel 2000
Sat, 20 Mar 2010 10:04:01 -0700
I'm getting an error opening an xlsx file in Excel 2000. I have tried
installing the 2007 Compatibility pack. I uninstalled and reinstalled Excel
2000 and the Compatibility pack. Ironically I've gotten it to work on
another of my computers (same version of Excel) but can't seem to get it to
work on my des ...
|
Find & Extract
Sat, 20 Mar 2010 09:05:02 -0700
hi,
I have data in Col A and i would like to get the data in Col B only if the
value in Col A is greater than 3 and less than 5 .
A B
1 2
2 3
3 4
4
5
6
I am looking for a formula. Any ideas on this please.
best regards,
Meeru ...
|
Randomizing
Sat, 20 Mar 2010 10:32:40 -0400
Hello All!
I have been using a sort on a helper column of random numbers [generated
by RAND() ] to randomize a data set but I notice that the column of
random numbers changes when I do the sort. Can any expert tell me if the
sort or the recalculation occurs first?
--
James Silverton
Potomac, Maryl ...
|
