Forum Discussion
Data pivot table lab data
Hi, I need to process some lab data with excel, and i think a pivot table is the solution for this. I was almost there, but now there is still a problem i cannot fix myself. I will try to explai...
Hi Hans, thank you for your help! But still not that what i should want. I need no sum or count, just the exact value that is linked to the sample ranked by row and analysis ranked by column.
A pivot table always summarizes data, either by counting them, or calculating the sum, average, ....
So a pivot table is not what you need...
- Ok thank you Hans. But i guess this must be possible with Excel of course.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Aub Hans, zie link hieronder. Zijn 2 sheets, ene sheet is de pure data in kolommen. Verder zou ik het niet openen in google spreadsheet maar gewoon in excel zelf.
https://docs.google.com/spreadsheets/d/1AYnDTSdM9cOl53LOzk5gS9VqF0sCX2zF/edit?usp=sharing&ouid=111645992358946016814&rtpof=true&sd=true