Thread: [Solved] Help switch rows to columns based on criteruim
View Single Post
 
Old 02-21-2022, 07:29 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Something like this?

Columns with colored headers on Datasheet sheet are calculated! You enter/select only Number, Absence type, and Days.

PS: Remove last column on Persons sheet! I forgot deleting it before posting!
Attached Files
File Type: xlsx Days.xlsx (21.4 KB, 10 views)
Reply With Quote