|
|
|
|
#1
07-30-2017, 12:36 AM
|
||||
|
||||
If you don't mind slightly rearranging your data, a PT will do the trick easily
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
#2
07-30-2017, 02:07 AM
|
|||
|
|||
|
Quote:
Pecoflyer, thanks for the help, but having to rearrange all the day columns and their data into one day column would be a lot of work. Is there a way I can do this by keeping all the day columns separate from each other at the top of the spreadsheet? Can I have the results to be like this... ...............Monday.....Tuesday ...............yes/no.......yes/no Joe.............3..1..........2...2 Sally............3..4.........4....3 Greg...........1...1.........0....2 thanks
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to calculate the Average time period of a full oscilation on a set of data | DDK2110 | Excel | 2 | 05-27-2017 02:15 AM |
 Trying to find a way to calculate subtotals for different sections of an invoice w/ data validation
|
excerbated123 | Excel Programming | 2 | 02-03-2015 09:28 PM |
|
how to input data vertically in spreadsheet?
|
mikehende | Excel | 3 | 10-10-2012 11:40 PM |
| Displaying cell data in another spreadsheet | Colonel Biggs | Excel | 0 | 07-01-2010 07:37 PM |
| Displaying data from spreadsheet in Userform | darklide | Excel | 0 | 03-12-2010 05:42 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode