Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return last 6 results formula
Hi
I have a column in my sheet that fills in progressively over a season as team results are entered. This particual column will show d for a goal-less draw (0-0), D for a score draw (1-1, 2-2 etc) and W or L for Win/Loss I'd like to show the last 6 game 'form' in this format: W,L,W,W,d,D using that column Any suggestions gratefully received Thanks in advance Neil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! All results of my formula are the same! | Excel Discussion (Misc queries) | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
referencing cells that return blank results | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |