I filter my data based on entries in field 8 and once I have that filtered I want a message box to pop up to let me know if there are any new entries.
The filtering works, and I know that the message box criteria is wrong since cell H2 won't be blank. It's just not in the filtered range, but...
Hello,
I am trying to create a word/phrase counter where it counts the contents of the cell (regardless of how many words are in there), and shows how many times it appears in the range. I apologize if it sounds confusing, but here is the example:
Source:
Genre
Number
Historical...
Hello,
I'm having trouble with something that seems pretty straight forward.
I have a worksheet with Dates and Blank cells in column A and would like to put "Open" if column A has a Date and "Closed" if column A has a Blank in column B.
I'm using the following code but am getting a 400 error...
Hi all!
I have this formula:
But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell.
Can...
I have a excel workbook having 70 worksheets. Now, I want to check if Row 13 on every worksheet is blank or not. If not blank, then I want name of that worksheet. Is there any excel formulae to get that detail without checking every worksheet separately?
Hello everyone:)
Maybe someone can share with an idea of macro, which will copy specific cell range to clipboard based on criteria of one column (if cell value is 0, copy to clipboard up to that 0)
Basically small example below, i need to copy all range from A4 to C12, so 12 rows, because row 13...
Hey everyone,
I was hoping someone could help with some ideas. I have an Excel report with multiple linked pictures, one after another in a vertical layout. Each of these linked pictures points to a named range, and each of these named ranges points to a specific pivot table. Some of these...
I have a Timesheet data table of 100 rows in a worksheet linked to a pivot table on another sheet. When the user completes the timesheet and refreshes the pivot "blank" appears and so there are no totals. The amount of data entered will be different each week. How can I set the pivot to refresh...
Hello,
For a document at work I need to calculate the total days that we have had someone stay at our property. Something that should look like below.
Room
Room (per person)
Date in
Planned Date Out
Actual Date Out
Total Nights
1511
1511
25/09/2020
9/10/2020
7
1511
25/09/2020...
Hi,
I have a cell that has an IF formula and a Form Control linked to it. If I click the up arrow, the cell input goes up one increment however the IF formula is removed.
How do I keep the rule in place but be able to manually enter quantity if value is true?
OR
Can I get the Form Control to...
I am looking for a formula that will count unique occurrences that start with W81UTH, ignoring duplicates and blank cells.
Also looking for a formula that will count unique occurrences that does NOT start with W81UTH, ignoring duplicates and blank cells.
I want to achieve the desired results...
Hi Experts!
I need to get the deadline of the following client:
Client Deadlines
A
B
C
D
E
The source data looks like this:
Deadline 10th-15th 16th-20th 21st-25th
Blank ClientA ClientB ClientC
Blank ClientD blank ClientE
What...
Hi
I created a combo box in the form to select the record and export to excel (I created a button). Please advise how to make the combo box with one blank at the top of the list so that I select the blank, then all record can be exported to excel.
Regards
Hi everyone,
Thank you in advance for your help!
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 142px"><col width="142"><col width="142"></colgroup><tbody>
A
B
1
10/24/19
=A1+10
2
#b7e1cd[/URL] , align...
Is there a formula that counts unique values in a column. I'm creating the data in col a and col b with vba
Existing output
ColA ColB ColC
User1
10.10.10.10
10.10.10.10
10.1.1.1
10.1.1.1...
Trying to write this formula and keep flat lining.
If G2 is a error (always #VALUE ), return blank...otherwise run the below if statement
IF(ISNUMBER(G2),"1","0")
Can anyone help I am really struggling.
I have a cell on sheet A that employs VLOOKUP from data from sheet B. The cells on sheet B have a date or is blank.
When it is blank the result is 0-Jan-00. How can I set it up so I get a blank like the other page?
=COUNTIF(Data[Column1],TRUE)
I have the above mention formula but i want to modify it to add that if Counts of Assets in BU is blank dont count the true
now is counting 1,221 but it should be 1177
Hi Guys
I have 3 columns A2:C10 where i put an Id in ie 12345
now some cells could have blanks, an Id or multiple Ids separated by a comma
what i want to be able to do is if the cell has an id or multiple ids then create a string like this
<found>
for some reason its lost my string concat
it...
Hello,
I've got an idea for a spreadsheet but am not sure where to get started. I have two tabs (Tab A and Tab B); each tab contains materials for a job. Each group of materials "A" column is the system into which the material was taken off. I would like to have all of my column A from Tab A...
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.