Hello All,
I am pretty new to excel, we get a helpdesk report in xls format consisting of different fields, as most of you must be aware each helpdesk case has a Resolve SLA & Response SLA, referring to the attached, I want to do the following.
1. Compare A2 & A3 & merge if contain same data
2. Compare B2 & B3 & merge if contain same data
3. Compare C2 & C3 & merge if contain same data
4. Compare D2 & D3 & merge if contain same data
5. Compare E2 & E3 & merge if contain same data
6. Compare F2 & F3 & merge if contain same data
7. Compare G2 & G3 & merge if contain same data
8. Compare H2 & H3 & merge if contain same data
9. Compare I2 & I3 & merge if contain same data
10. Compare J2 & J3 & merge if contain same data
11. Compare K2 & K3 & merge if contain same data
I have an excel sheet with about 30000 records of attached sample.
Any help would be a life saver, requesting your assistance.
Thanks
Sachin Palav
Bookmarks