Hi
I have a list of dates in E5 to E7, in long date format. I have a form control with an input range of E5 to E7.
The cell M5 also has long date format and is the cell link for the format control.
Cell M5 does not display the correct dates from the dropdown list and instead displays 1,2 or...
When trying to count a particular group (Group 1 or Group 2) I am getting the correct data (1)
How to get the overall data (2) using COUNTIFS
<tbody>
Group
Status
Group 1
Not Started
Group 2
Not Started
</tbody>
=COUNTIFS($B:$B,"Not Started",$A:$A,"Group 1")
hi everyone,
I have 7 cells in a column which are conditionally formatted. I'm trying to write some code based on any cells that are coloured vbRed or another message if none of them are.
I've copied most of the code from previous threads but I still cant get it to work, so any help would...
I have the following code in my macro:
itemnocol = Application.Match("Item#", Worksheets("Prices").Range("1:1"), 0)
banana = Application.Match("Dist Price", Worksheets("Prices").Range("1:1"), 0)
I get the correct answer for "itemnocol", but using the exact same wording, I get an "Error 2042"...
Hi,
I need help with this simple calculation in Excel that I am having difficulty with. I have tried couple of formulas so far and nothing is giving me the correct answer. The formulas are displayed in "MyProduct#1" and "MyProduct#2" columns.
So the "Original table" is what I am working with...
Hi,
I am trying to use a Multiple IF formula to help me give the values if the following conditions are met, but it gives me a #Value error.
Could you please help me figure out the correct formula for this.
Thank you
=IF(AND(B2034<>B2035),H2035+I2035-J2035,IF(ISNUMBER(SEARCH("Beginning...
First off, sorry for the one off question.
My district has tasked me with assigning serial numbers counted at my site with the partial outputs from their SAP system.
So, after extracting my site's inventory and inserting my counts into it for conditional formatting compare-n-contrast...
Hello
This is something that has happened to me some times but never understood why.
I'm doing a simple calculation which I can easily do in my head, and the answer should be 0 but excel returns a negative 0.
Upon further inspection the 14th decimal position has a value, but it should be 0...
Please help. Looking for an equation that will calculate the Max concurrent rooms in column D between each start and stop date/time. Column D has what the correct answer would be. If possible would also like the MIN in column E which also has the correct answer. Correct answers are included to...
Hi
I can not find what i am doing wrong with this code.
Access does not give me any error message... it just does not show the correct data that i expect.
I use this code to filter in a listbox.
the problem is with the row in bold. It is something there that is not correct and i cant figure...
Hi,
I've been working on a formula for this for a while but haven't been able to crack it, any help appreciated.
The data I have is peoples ages, and I want a formula to be able to take the age and automatically assign it to the correct age band.
So I need to combine the following into one...
I need to Check in Sheet 1 the sum of the field “Long” is equal “Long” in Sheet 2 for the same “code” when “Ap” is “0 “”. If this is not correct put in sheet 2 in column “Sum” the value “Not correct”. The problem on this code is that value “Not correct” put on when the “AP” is for example 1...
If someone could point me in the right direction with a link and/or an example line or two of code, that would be fantastic.
I have two workbooks, and a colleague will be updating one of them sporadically. I'd like to create a command button that will update the differences between the two...
Hi,
Looking to count all the numbers in range H:H but only if A:A contains the value in cell V28 & G: is blank.
COUNTIFS but struggling with correct syntax.
Hello group,
Looking for why the following line doesn't work as expected on occasion (probably about 15% of the time)
l_rngCurVerse.Characters(l_lngStartPositionOfOldAnnotation, l_lngLengthOfOldAnnotation).Text = l_strCurrentVerseAnnotation
I can see all of the variables in this particular...
Looking for advice on a macro to save an excel template to a dropbox location. This will be for multiple users that open a fresh template and then would like them to be able to click a button that saves the correct file name and too the correct location for management review.
I'm making an...
Hi All
I have a 13 hidden sheets in my workbook, Based on the users input the correct sheet to unhide shows in sheet6 cell E10 ie (Upload A or Upload B etc).
My question is using VBA how can I make clicking a button unhide the correct sheet?
Any help is much appreciated! Thanks
Tom
Hi,
I have a spreadsheet that needs to highlight cell on column A if column D is >=20 and column O does not contain “TOR”.
My current codes are below but its not capturing the condition for column O. Can you help me correct my codes?
Range (“A4”). End(xldown).activate
Do until...
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.