Identifying the last visit

S

Sarah (OGI)

The following formula is used to show the value of the last figure that was
entered into any one row in my spreadsheet, looking at every 4th cell from
G12 to AN12.

=IF(COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12)=0,"",INDIRECT(CONCATENATE("R",ROW(),"C",((COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12))*3)+4),FALSE))

I would like to use a similar formula, which would find the last figure
entered in any one row, but rather than showing the value of that cell, I
would like to show the value of the column header. For example, if the last
figure entered was in cell V12, I would like the result to show the value of
cell V1, the header for column V, i.e. Visit 6, so I know what the last visit
number was.

Any ideas?
 
B

Bob Phillips

Using your formula

=IF(COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12)=0,"",INDIRECT(CONCATENATE("R1C",((COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12))*3)+4),FALSE))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
S

Sarah (OGI)

That's great, thanks!

Bob Phillips said:
Using your formula

=IF(COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12)=0,"",INDIRECT(CONCATENATE("R1C",((COUNT(G12,J12,M12,P12,S12,V12,Y12,AB12,AE12,AH12,AK12,AN12))*3)+4),FALSE))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top