Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2014, 07:22 PM
BobBridges's Avatar
BobBridges BobBridges is offline How to replicate, consolidate and count cell data in excel for data consoldation. 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
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default


2) When I change data for Susan and Ivan, the results rows change immediately. Do you have calculation set on manual or automatic?

3) R7C2 is set to 1 because it can't add anything to the previous column (which is text), and the first number in that row should always be 1. But I don't think this should cause any trouble; my theory (see above) is that something else is causing that problem.
Reply With Quote
Reply



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
How to replicate, consolidate and count cell data in excel for data consoldation. Excel 2007, highlight entire row based on data found in one cell MSofficeBLUE Excel 2 10-15-2013 09:51 PM
How to replicate, consolidate and count cell data in excel for data consoldation. 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.


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