![]() |
Find a year in cells....
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 - - |
All times are GMT +1. The time now is 03:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com