I have read the thread on how to count only visible cells with other criteria, but I don't understand how to generalize this to my situation.
Here is the originial countif statement:
=COUNTIF(Data!T:T,"*"&B3&"*")
Here is the code that I have copied from previous threads, with my numbers...
Hello,
I'd like to be able to compare the data between two different worksheets to see the differences and then merge them together. Can anyone help? Thank you!
;)
Hello MrExcel, i want you to help me now.
How we get a coloumn that contain an updated list data entries directly from a running and real time recording?
example:
Day 1st
Time Name Buy
07.00 John 5 units
07.30 Smith 2 units
09.00 Alexa 3 units
10.15 John 2 units
Day 2nd
Time Name Buy
07.15...
Hi
I have a quick easy question i have this code which works fine on my worksheet but i need it to look down the whole Coloum of R(i have highlighted below) at the moment it looks down the list and as soon as there is a gap it stops?? for example
ColoumR
Complete
Complete This will copy to other...
Hello,
I'm in need of some help regarding Excel and lookups functions.
My worksheet contains 2 tabs.
Tab 1 - Contains Employee Names and Projects they're on.
Note * Their names may be listed multiple times. (Once for each project)
Example -
Joe Smith Project 1
Bob White...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.