Need data result in last cell of array that contains blank cells
in [General]
|
Prev: add rounded numbers using the rounded value
Next: Looking forMacro to do this Sheet to Sheet copy &sort
From: smesurfer on 8 Feb 2010 15:21 Example: A1=200 B1=300 C1=400 D1=[blank] E1=[blank] F1=[blank] G1=(last cell from above that contains data...i.e. C1) I'm a bit of an Excel novice so could really use a little help. Thanks!
From: Ron Coderre on 8 Feb 2010 15:29
Assuming that range will only contain numbers, try something like this: =LOOKUP(10^99,A1:F1) or...if you want to avoid an error when there are no numbers: =IF(COUNT(A1:F1),LOOKUP(10^99,A1:F1),"") Does that help? *********** Regards, Ron XL2003, WinXP "smesurfer" wrote: > Example: > > A1=200 > B1=300 > C1=400 > D1=[blank] > E1=[blank] > F1=[blank] > G1=(last cell from above that contains data...i.e. C1) > > I'm a bit of an Excel novice so could really use a little help. > > Thanks! > > > |