| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent simple formula help
<<Any further ideas?
No. Your choice. To use VLOOKUP you will need to swap columns A and B to facilitate the LOOKUP. Alternatively, you could replicate column A after column B. You could do that with a formula; in cell C1 put the formula =A1 and drag down. Not sure what you are trying to achieve ... intellectual exercise ? Other than that, no, no ideas. The solution offered works. Regards Trevor "pinehead" wrote in message ... Thank you for your response, however i'm attempting to do this example withonly certain formulas in use. My goal is to only use max,min,count,countif,sum,sumif,if,average or vlookup Any further ideas? Thank you Anthony -- pinehead ------------------------------------------------------------------------ pinehead's Profile: http://www.excelforum.com/member.php...o&userid=31721 View this thread: http://www.excelforum.com/showthread...hreadid=514291 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weird issue with very simple line chart - urgent | Excel Discussion (Misc queries) | |||
| Urgent - Simple Workbook Protect | Excel Discussion (Misc queries) | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple Question but need urgent help pls... | Excel Worksheet Functions | |||
| URGENT.....Simple problem...made hard?? | Excel Programming | |||
Threaded Mode
