Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Help switch rows to columns based on criteruim Help switch rows to columns based on criteruim
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-21-2022, 07:29 AM
ArviLaanemets ArviLaanemets is offline Help switch rows to columns based on criteruim Windows 8 Help switch rows to columns based on criteruim 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
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help switch rows to columns based on criteruim Delete blank table rows in merged document and split document in docx and pdf based on excel rows Alex1s85 Word VBA 5 05-22-2021 12:05 PM
Help switch rows to columns based on criteruim Transposing Columns and Rows in skeezix Excel 8 04-30-2020 08:23 PM
Hide rows in multiple columns based on zero values Deane Excel Programming 19 06-23-2015 11:24 PM
Help switch rows to columns based on criteruim Stack columns into rows stellag09 Excel 1 04-23-2014 03:26 AM
Help switch rows to columns based on criteruim Rows to Columns kyakobi Excel 5 12-07-2010 03:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft