How to replicate, consolidate and count cell data in excel for data consoldation.

		Microsoft Office Forums > Microsoft Excel > Excel
How to replicate, consolidate and count cell data in excel for data consoldation.

FAQ

Thread Tools

Display Modes

06-04-2014, 08:00 AM

BobBridges BobBridges is offline

Windows 7 64bit How to replicate, consolidate and count cell data in excel for data consoldation.

Office 2010 32bit

Expert

Join Date: May 2013

Location: USA

Posts: 700

Here's a sample solution using formulae. The first part, to get your row 8 (my 9) turned out to be simpler than I thought. The whole thing is a little kludgy; I'd probably write a worksheet function, myself, especially if the actual data is much, much larger.

Attached Files

x.xlsx (9.8 KB, 15 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1	bobznkazoo	Excel	2	03-27-2014 11:14 AM
Excel 2007, highlight entire row based on data found in one cell	MSofficeBLUE	Excel	2	10-15-2013 09:51 PM
Excel Cell Data in a Word doc	Jagobezzer	Word	1	09-30-2013 06:18 AM
How to count the frequency of data and also tally value from an array of Excel record	KIM SOLIS	Excel	5	09-07-2011 09:01 AM
How to count cells containing data and meet certain criteria	AdamNT	Excel	1	08-11-2006 11:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 AM.