Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 09-02-2014, 12:02 PM
gebobs gebobs is offline How do you count how often a specific value occurs in single changing cell? Windows 7 64bit How do you count how often a specific value occurs in single changing cell? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

If I'm not mistaken, that will require code and I'm a rusty on my Excel VBA, order of events, etc. I think something like this would work.

Add a button. When pressed, run the code:

Check value of A2 and store in variable, A2Value.
Recalculate
A2=A2+A2Value
End sub

Perhaps repost this in the Excel Programming forum. I'm not sure if it will get any more looks here now that I've responded and bungled it all.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you count how often a specific value occurs in single changing cell? Sum values within a single cell shabbaranks Excel 17 05-13-2014 06:47 PM
How do you count how often a specific value occurs in single changing cell? count how many tims a certain value occurs lucnijs Excel 6 03-26-2012 09:29 AM
How to count year lapse (rounded off) based on specific date KIM SOLIS Excel 1 11-01-2011 10:50 AM
How do you count how often a specific value occurs in single changing cell? How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
changing word count hamster Word 3 06-03-2010 01:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:55 PM.


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