# blank

1. ### 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...
2. ### 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...
3. ### 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

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...
5. ### 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 10.10.10.10 10.10.10.10 10.1.1.1 10.1.1.1...
6. ### 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.
7. ### 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?
8. ### 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
9. ### 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...
10. ### 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...
11. ### Concatenate multicoulmns but not display blank coulmns in the total formula

<tbody> B C D E F 1 SURNAME FIRSTNAME MI GENQUAL CONCAT'D 2 DOE JOHN T JR DOE.JOHN.T.JR 3 DOE JANE DOE.JANE </tbody> I cant figure out how to write a formula to concatenate column B thru Column E, add a period after each column, but not display a period if the field is blank. In the...
12. ### Struggling with nested functions

Can someone please help me to write the following formula? Conditions: if A1 and B2 are blank and A2 and B1 are NOT blank If True: = A2 If False: (leave cell blank)
13. ### SUMIFS Frustration

G'day Excel Gods, I normally have no issue with SUMIFS, but I have one spreadsheet that is kicking my butt and driving me insane! I want the total from Column E based on the value in Column B, however I need to exclude the value in Column E if Column C is blank. The formula I have is...
14. ### Pivot Table returning Zero instead of Blanks

Hi I have a pivot table which is taking data from a field which is populated as follows =IF(VLOOKUP(B90,'Order Download'!A:BP,62,0)="","",VLOOKUP(B90,'Order Download'!A:BP,62,0)) If this lookup returns a value, all good and i get that into the pivot. If it returns blank (which is the same...
15. ### Concatenate Multiple Rows until Non-Blank in Adjacent Column

Hello I would like a macro that works through a long worksheet, set up as follows: Column A: product code (3-digit code) Column B: notes about product (free text - can span multiple rows due to character limits) Column A is blank in the rows where the data in column B has spilled onto...
16. ### Max unless blank

I would like to calculate the Maximum date resolved from a column of resolved dates, unless there are blanks in the resolved dates column. If there are blank cells in the column, I would like the result to come back as blank. The intent is to highlight whether there are outstanding service...
17. ### count rows down in column from blank to blank

is there a function that I can insert that will count the # of rows containing data, counting downward until finding a blank row? im using a vba script that builds the data and I i could insert somekind of function if there is one (perhaps?) the data looks like this...
18. ### Text to Columns on Two, or more, blank spaces?

In Cell A1 I have a Huge Text String that originated in a .pdf file. There are no useful delimiters, such as commas or semi-colons. any text that has two or more spaces between is a field in the original .pdf is there a way to split this out is by using two or more blank spaces as the delimiter?
19. ### Formula finding highest to smallest values

Hello, Is it possible to add into below formula that if there is no value on the cell V3 the formula will not show any result.The cell will kepp blank unless there is no data on the cell V3 Many Thanks...
20. ### Store row numbers in an array

I've got 2 types of data and thought it might be a good idea to use an array to store the row number in for subsequent processing; is this a better solution than ifs & loops ? Both sets of data are in blocks of approx 4 to 7 rows but each block in its raw form is separated by a blank row so...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...