Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I want to find the current year in a row, the positive results will be selected so I can see the months in order to find if what month that person paid. like the example bellow: name Nov-05 Dec-05 Jan-06 Feb-06 Peter - - 10 10 tim 10 10 10 10 If I'm searching for the year 05 and for Tim i want the result to be in a different table like this: name Nov Dec tim 10 10 But if I'm searching for the year 05 and for Peter i want the result to be in a different table like this: name Nov Dec Peter - - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find a year in a string of dates | Excel Discussion (Misc queries) | |||
How to find the year from a given date | Excel Discussion (Misc queries) | |||
Find Last Saturday of the Year | Excel Discussion (Misc queries) | |||
Find the first Sunday for a given year? | Excel Worksheet Functions | |||
want end of year balance sheet where to find it | Charts and Charting in Excel |