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, 07:43 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

And do you need just the final answer (ie 1), or are the intermediate numbers important too?

All this is easy enough to do in VBA. How to do it with formulae...well, I'm sure it can be done, but it'd take some work. Are you up for a programmed solution, or do you want it in formulae?

« 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 06:22 PM.