Hello all,
I have a fairly simple spreadsheet with the following items. I would like to run several different reports based on Index and PSD associated to Sample. One report would show Sample - Index = a and sorted based on the PSD. I may be forced to use numerical values for PSD in of X's. Another report may include the entire dataset based on Index sorted a-z but also sorted via PSD. I thought perhaps a Pivot table, but don't get the results I wanted. At this point I am not even sure how to even start to figure out how to generate such a report. Is there anything inherent in Excel that will accomplish this task? I thought about copying over the data to a new worksheet and doing something as simple as a Data Sort. The PSD X's didn't cooperate with that process.
Any ideas or pointers in a certain direction greatly appreciated.
Sample Index PSD
426 a x
123 c x
32 a x
444-446 a x
50 a
51 a x
30 a x
73 b xx
431 a xx
374 a xx
378 bc xx
85 a xxx
I have a fairly simple spreadsheet with the following items. I would like to run several different reports based on Index and PSD associated to Sample. One report would show Sample - Index = a and sorted based on the PSD. I may be forced to use numerical values for PSD in of X's. Another report may include the entire dataset based on Index sorted a-z but also sorted via PSD. I thought perhaps a Pivot table, but don't get the results I wanted. At this point I am not even sure how to even start to figure out how to generate such a report. Is there anything inherent in Excel that will accomplish this task? I thought about copying over the data to a new worksheet and doing something as simple as a Data Sort. The PSD X's didn't cooperate with that process.
Any ideas or pointers in a certain direction greatly appreciated.
Sample Index PSD
426 a x
123 c x
32 a x
444-446 a x
50 a
51 a x
30 a x
73 b xx
431 a xx
374 a xx
378 bc xx
85 a xxx