Yes that worked, thanks!!
Wed, 17 Mar 2010 11:36:33 -0700
Yes that worked, thanks!!
Bernard Liengme wrote:
Here is the formula=SUMPRODUCT(--(data<>""),1/COUNTIF(data,data&""))replace
15-Mar-10
Here is the formula
=SUMPRODUCT(--(data<>""),1/COUNTIF(data,data&""))
replace 'data' by the range (such as A1:A100)
or name that range as "data"
best wishes
--
Bernard ...
|
Unable to hide columns
Wed, 17 Mar 2010 10:19:30 -0700 (PDT)
I am trying to hide some columns which have no data, but get a
message:
"Cannot shift objects off sheet"
I'm not trying to delete the column, simply trying to hide it.
And I can't find any objects in the column in the first place.
I appreciate any explanation
Thank you,
Tony Bender ...
|
Strange Display Issue - small table
Wed, 17 Mar 2010 10:52:13 -0400
I have encountered an Excel file where the table has been resized to about
1/4 of the size of the main Excel window. See here for a screencap:
http://drop.io/5uv2svl/asset/strange-excel-display-jpg
I have looked at all the settings in Excel and can't figure out how to make
the table go back to full screen. ...
|
Calculating times
Wed, 17 Mar 2010 20:47:46 +1100
I make spreadsheets for bike rides. I have the itinerary with the departure
point, stops along the way and the destination.
I cannot get Excel (2003 or 2007) to correctly calculate the times between
stops.
I'd like to punch in an average speed, then using the distance between stops to
calculate the time tra ...
|
Lookup more then one sheet as reference
Wed, 17 Mar 2010 01:14:13 -0700 (PDT)
Hi,
Is there a way to extract the data from an workbook that contains the
data in more then one sheet.
i.e.
I have the address data of the employees in 30 sheets (30days) that
was typed in same format and I want to pull the data (with sheet name
if possible) by entering Emp ID and name in separate workbook ...
|
Unable to open Excel 2007 file by double-clicking...
Wed, 17 Mar 2010 15:03:50 +0800
OS is Vista Home Basic. I've done repair installation but didn't fix the
problem so I remove Office 2007 completely and reinstalled back but still
didn't fix the problem. Apparently, when double clicking Excel 2007 file
the cursor will change from arrow to ring-like icon for a split second then
nothings h ...
|
Find/Replace Question
Tue, 16 Mar 2010 19:33:12 -0700
This happens almost everytime I use Find/Replace, but I just deal with
it. Maybe you guys can set me straight on this.
I have the following formula:
=SUMPRODUCT(--(MOD(ROW($AB$14:$AB$1008)-ROW($AB$14),4)=0),--(ISNUMBER($AB$14:$AB$1008)),--($AB$14:$AB$1008>0))
I want to replace all of the ABs with AK. So ...
|
|
|
VLOOKUP returns formula instead of result
Tue, 16 Mar 2010 14:50:01 -0700
When I do a VLOOKUP formula, the cell returns the text of the formula instead
of the result. I get the correct result when looking the in Formula Wizard
grey box, but when I get back on the worksheet only the formula is displayed.
This is not a case of Ctrl+~ to look at formulas. Any suggestions??? ...
|
I can't get Excell to do automatic backup
Tue, 16 Mar 2010 12:20:10 -0400
With Word, I can to Options/Advanced/Save and choose to Always create backup
copy. Then, every time I resave a Word 2007 doc, I get the backup with a
.wbk file extension.
I just can't figure out how to do the same with Excel.
There is no comparable Options/Advanced/Save choices. I do see in Word the
Auto ...
|
Need help with a formula
Tue, 16 Mar 2010 08:03:32 -0700
I have this formula: =INDEX(L11:L131,MATCH(99999,L11:L131))
It was working and now it doesn't. Cannot figure out why. I need help.
It's supposed to work like this:
There is an array, for example B1:B4 and a cell A1
Initially;
B1 = Null A1 = Null
B2 = Null
B3 = Null
B4 = Null
First Pass
B1 = 20 ...
|
