1. A

    If filtered range is blank, message box

    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...
  2. C

    Count Words in cell and ignore blanks

    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...
  3. U

    If a cell in column A is not blank then column B equals

    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...
  4. Jyggalag

    IFBLANK formula but with specific text as well

    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...
  5. V

    Checking if a row is blank on every worksheet

    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?
  6. J

    VBA macro: Copy to clipboard table range up to 0 in first column as criteria

    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...
  7. J

    Dynamically move linked pictures, to avoid overlaps / blank gaps between them

    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...
  8. S

    Pivot auto-update w/o "blank"

    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...
  9. V

    Combining ISBLANK and NOT(ISBLANK() to calculate dates..(or other suggestions)

    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...
  10. M

    Keep IF formula but be able to change quantity if value is true

    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...
  11. J

    Formula help, counting unique occurences.

    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...
  12. A

    Get the Dates

    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...
  13. B

    Combo box

    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
  14. M

    Please help!! Need help with specialized formula.

    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...
  15. D

    formula for count unique?

    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
  16. B

    Nested IFERROR/ISERROR statement

    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.
  17. T

    Rather have blank cell than 0-Jan-00

    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?
  18. L

    CountIf True

    =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
  19. M

    VBA create string array

    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...
  20. C

    Matching cells, adding blank lines

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

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
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 "".
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.
Go back