Excel Report

bjwheeler

Board Regular
Joined
Apr 9, 2004
Messages
74
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
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

lozzablake

Well-known Member
Joined
Dec 15, 2005
Messages
818
Could you perhaps give an example of the result you are looking for. It is not clear to me from your explanation exactly what you want eg Sample-Index when Index is a letter.
 

bjwheeler

Board Regular
Joined
Apr 9, 2004
Messages
74
Does this help any. I got away from using X's for the PSD and went to numbering instead. I need to generate several reports - the one with all may be as simple as a Sort, but the others require more user interaction which is what I am trying to avoid. The dataset isn't very large - perhaps 100 rows at most.<SCRIPT language=JavaScript src=""></SCRIPT>
Model Test.xls
ABCDEFGHIJKLMNO
1RawDataReportAllReportIndex=AReportIndex=B
2
3SampleIndexPSDSampleIndexPSDSampleIndexPSDSampleIndexPSD
4426a0426a0426a0123b1
5123b150a250a251b2
632bc3123b132bc3
7444c151b2
850a232bc3
951b2444c1
Report
 

jdee

Active Member
Joined
Sep 10, 2003
Messages
276
I used a pivot table and it appears from your description that it covers what you desire, that is, if I'm reading your question right.

Attached below:

Sorry, lost html maker - will submit after downloading again. J.Dee
 

jdee

Active Member
Joined
Sep 10, 2003
Messages
276

ADVERTISEMENT

<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Sample</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Index</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>psd</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>426</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>123</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>c</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>32</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>444</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>50</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>51</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>30</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>73</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>b</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>431</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>374</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>bc</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>378</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>85</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>d</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>32</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Sum of psd</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Index</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Sample</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>a</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>b</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>bc</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>c</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>d</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Grand Total</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>30</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>32</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>50</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>51</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>73</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>85</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>123</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>374</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>378</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>426</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>0</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>431</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>444</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
</tr>
<tr>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>Grand Total</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>21</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>32</nobr></font></td>
</tr>
</table>
 

jdee

Active Member
Joined
Sep 10, 2003
Messages
276
Book1
ABCDEFG
1SampleIndexpsd
2426a0
3123c1
432a3
5444a2
650a6
751a4
830a1
973b2
10431a1
11374bc6
12378a4
1385d2
1432
15
16SumofpsdIndex
17SampleabbccdGrandTotal
183011
193233
205066
215144
227322
238522
2412311
2537466
2637844
2742600
2843111
2944422
30GrandTotal21261232
Sheet1
 

bjwheeler

Board Regular
Joined
Apr 9, 2004
Messages
74
jdee,
That is what I am looking for. I guess I better learn how to use a PivotTable because everything I tried didn't get me the results you show above.
 

jdee

Active Member
Joined
Sep 10, 2003
Messages
276
Glad I could be of help - Pivot tables are great and provide lots of reports in just a few seconds.

Here are the steps used to create the one I showed you: Keep in mind you can create many-many more than this type.

Go to: Menu Bar
Data, Pivot Table, choose Excel List, Pivot Table (defaulted)
Choose Next, highlight your data you wish to use, next, choose where you want your pivot table, i.e., new worksheet - or this worksheet and where, then choose layout,
now, in the Row Area I put the Sample Heading, (located on the right of the pivot table window as that was the headings used in the data), and in the Column portion I put the Index Heading and in the Data field I used
the PSD (using the sum function) there are count functions, etc., then choose finish. There you have it - your pivot table.
 

Forum statistics

Threads
1,137,296
Messages
5,680,672
Members
419,924
Latest member
Dhamodharan992

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top