Afternoon All
I am attempting to analyse data from multiple worksheets from numerous
people the incoming data all has one thing in common column A this is a
certain frequency a job is done. The problem is that there are many ways of
entering the data ie 12 months or 52 weeks or 365 days all essentially
meaning the same thing.
My idea is to collate the data in col A and then using the Helper column as
the standard frequencies ie if cell A1 = 12 months, closes frequency in
helper is 52 weeks therefore value in C1 = 52 weeks. By using an IF
statement I can change the value of one frequency as above however when it
comes to manipulating all of the different possible values in A I get a bit
lost. This may not be practical if so please let me know and I will get some
sleep
Thanks in Advance
Ajay


Col A Helper Col Col C
12 Months 4weeks 52 weeks
182 Days 8weeks
24 Months 12 weeks
26 Weeks 13 weeks
28 Days 17 weeks
36 Months 26 weeks
3 Months 52 weeks
4 Months 104 weeks
52 Weeks 156 weeks
6 Months
90 Days