292 reputation
311
bio website linkedin.com/in/…
location Pune, India
age 42
visits member for 4 years, 5 months
seen May 12 at 9:29
I moved from being a developer and am currently a business analyst in the banking domain.

May
29
awarded  Popular Question
May
3
awarded  Constituent
Apr
29
awarded  Caucus
Nov
27
comment I need to find the last Space in a XLS Cell
Thanks for clarif. Does make some sense now. Which means Find itself implictly works with the array and gets executed for every value as starting position ...
Nov
27
comment I need to find the last Space in a XLS Cell
works great. Although I was developer some [long] time ago I still can't figure out how and why INDIRECT works :)
Nov
26
accepted I need to find the last Space in a XLS Cell
Nov
26
comment I need to find the last Space in a XLS Cell
Works perfect. Thanks. It took me a while to figure out why it worked inspite of your explanation :)
Nov
26
asked I need to find the last Space in a XLS Cell
Sep
19
revised Can I reuse the licence of Windows XP from laptop to desktop
added 76 characters in body
Sep
19
accepted Can I reuse the licence of Windows XP from laptop to desktop
Sep
19
asked Can I reuse the licence of Windows XP from laptop to desktop
Aug
13
awarded  Student
Aug
13
awarded  Commentator
Aug
13
comment Finding a Zero Value in one column and the corresponding value in 5th column from previous row
Yes Indeed, got a hold of the function. Thanks.
Aug
13
awarded  Scholar
Aug
13
accepted Finding a Zero Value in one column and the corresponding value in 5th column from previous row
Aug
13
comment Finding a Zero Value in one column and the corresponding value in 5th column from previous row
Sorry figured out the offset much better now =OFFSET(E2,MATCH(0,A2:A10,0)-3,0)
Aug
13
comment Finding a Zero Value in one column and the corresponding value in 5th column from previous row
Thanks. I had figured out the MATCH portion, but was not able to figure out the Ofset function. The value in Column 5 although shows zero [computed field] is really some small decimal ... 5 zeros after decimal :). So changed the MATCH to -1 and its giving me the desired result. If we can find something based on Year column that is zero it would be perfect.
Aug
13
revised Finding a Zero Value in one column and the corresponding value in 5th column from previous row
edited body
Aug
13
comment Finding a Zero Value in one column and the corresponding value in 5th column from previous row
There will be no Zeros in either column 1[Year] or in Column 5 [Amt 5]. However there can be zeros in other columns Amt1, 2, 3. So essentially I need the last non zero value in column 5.