How do I do this?

		Microsoft Office Forums > Microsoft Excel > Excel
How do I do this?

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-03-2016, 09:00 AM

gebobs

Windows 7 64bit How do I do this?

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

I can think of a way but it's not a formula.

* Data:Sort (by Date then Month)
* Data:Remove duplicates
* For each month, select the dates and do Paste Special:Transpose
* Delete the extra rows of months.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 AM.