| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
1-7 Columns, to find last column with figure in
Hi I have prices in Mo, Tu, We, Th, Fr, Sa, Su Columns. These figures arrive from information inserted in different sheets called Mo, Tu, We, Th, Fr, Sa, Su. What I would like to know is, what formula would be best to use to check which column had a price in last. Say Mo R10, Tu R12, We R13 Tu, Fr, Sa, Su, and it will give the answer R13 (which is Wednesday) Can anyone recommend something? Thanks Sonar -- sonar ------------------------------------------------------------------------ sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424 View this thread: http://www.excelforum.com/showthread...hreadid=400942 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match and count words | Excel Worksheet Functions | |||
| How do I incorporate 2 columns into 1 column | Excel Discussion (Misc queries) | |||
| Macros for find and replace and then joining columns | Excel Discussion (Misc queries) | |||
| print 3 column range in six columns | Excel Discussion (Misc queries) | |||
| How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
Threaded Mode
