PDA

View Full Version : Merging cells based upon values



sohketa
04-30-2013, 06:06 AM
Hi
I have two spreadsheet one with a data and another spreadsheet to show data as graph.
As there are around 1600 rows so i am trying to use rows and columns to represent data.

Example: Data tab cell C5 has value of 1 and it belows to ACZ0 and the values is between 0.0625 and 0.1250

so in Graphs tab cell A3 and A4 has a value of 0.0625 and 0.1250 and value ACZ0 is in column B so i have merged B3 and B4.

By any means can i automated this process.

Thanks a lot.