Hi
provide us with your exact mapping rules and the source values.
Probably a VLOOKUP formula would do. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Ajay" schrieb im Newsbeitrag
...
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