blanks

Afternoon all This Script highlights Unique values in Range A:C - Only issue is that it also highlights blanks which are in the Dic. Is there a way to exclude prior to adding to dictionary I suppose? Thank You Sub hUnique()Dim lastrow As Long Dim r As Range Dim dic As Object lastrow =...

Need help from excel masters, I have a userform enclude 3 comboboxes, and I have 3 columns (A) for Branches (B) for Departments and (C) for Names A2:c5000 the 3 lists are related and has duplicate and some blanks, what I want to do that when I choose a branch name in first combobox I want to...

Hey guys, I have a dropdown list that I am trying to create. I have looked at several other places on the internet to try and solve this, but have been unsuccessful. I've done a run-around with Dyanamic Data, Data Validation and conditional statements and am back to square one. You guys always...

I am looking to find the Min date from 3 cells that are not a range. I thought to use MIN, however, there are cases where the at least one of the 3 cells are blank. Example: =MIN(J23,I97,I78) Cells J23, I97, I78 are all populated by formulas which can sometimes have a blank ("") results. My...

Hi there. I have this formula {=AVERAGE(IF(Data!B:B=G6,Data!L:L))} but its including the blank cells in the average calculation. My question is , is there something i can include to ignore these blank cells? Many thanks in advance

How do i sum a column but omit if the cell is blank? This is the formula I have now: =SUM(L87,L83,L79,L75,L71,L67,L63,L59,L55,L51,L47,L43,L39,L35,L31,L27,L23,L19,L15,L11) I can't do the sum(L11:L87) because it gives be the numbers in between as well. Thank you,

Hi there I have the existing formula =COUNTA(AL23:AL169)/COUNTBLANK(AL23:AL169) which displays the result 93% I want to change it so it counts the blanks cells AND those cells which are 0 or "-" then displays that total number of cells as a percentage of overall number of cells, i.e. the 93%...

Hello All, I would like to have a macro which finds the header "Blogs" in the input sheet --> Then apply the filter to identify "NA" and Blanks --> Then replace the blanks and "NA" with "No" --> then take out the filter. Note: Somtimes Header "Blogs" might not be available in the sheet for...

I have seven day columns, with blanks and entries, I have a formula to identify the last ROW of each day, and use a MAX function to return the row number. so far so good I need to use =COUNTBLANK(M14:S34)+COUNTA(M14:S34) and =COUNTA(M14:S34) to be able to identify the difference between...

Hi, How do I get excel to ignore the blank cells in this formula? =SUM($W$5+$W$17+$W$29+$W$41+$W$53+$W$65+$W$77+$W$89+$W$101+$W$113+$W$125+$W$137+$W$149+$W$161+$W$173+$W$185+$W$197+$W$209) Thank You.

Hi Team, I have been using power query for a few months & this week it decided to corrupt on some new reports, moving data across columns due to blanks in some fields. Originally this was not an issue, but not i cannot find how to set the Null before importing & am exhausted for ideas...

I have a data validation list in one of my cell. The list range that it is looking at A1:A57 has some blank cells. I don't want the pull-down list (From the Validation list) to show any blanks. Is there a way to do this? If not is there another way to do this

How how would I count the unique (Return in A1) and extract the unique from H6:N16 please (Returns A3 downwards)... Range H6:N16 contains blanks...

Hi, Having trouble with this I'm wanting to copy from sheet1: Columns C + G (only rows with data) To Sheet2 (columns A+B) last row So Sheet2 should never have any blanks between rows Appreciate any help Was thinking maybe an advanced filter then copying the filtered range to sheet 2 but...

Hey All hope all is well, I'm hoping to get a little help with a notification when a date is near expire date. I have several columns of when employees training certificates expire, I would like excel to tell me in A:7 that the dates expire soon. some of the columns have blanks, I have this...

Hello, and thanks for clicking into my posting. I am hoping that someone can offer some guidance with what I am trying to achieve. I am admittedly an excel novice, so I am having a difficult time finding a solution. The sample data below (beginning from column C) is pulled into a workbook...

Dear friends n respected seniors I am finding it very difficult to solve this problem, bcoz of blanks in array. :( i want to get the smallest number from a group of numbers separated by a blank I have this data in column J starting from j1 , and data in column K is the required result entered...

Would appreciate some help please. I have quite a large dataset that gets updated on a monthly basis (100,000 rows +). There are 4 unique provinces each 10 unique counties in each province. The users that enter data into the form - using drop down boxes - that generates these fields (among...

Hi, I have a sheet with upto 10000 rows of data, on another sheet I need to have a draggable formula to make a list of all the values in col C where Col AD has a positive number. I would like this list to be without blanks as out of the 10000 rows there will not often be more than 10-20 values...

Hi, I have data in columns B2:B9, D2:D9 and F2:F9. Some of those cells have blanks. I would like to combine them into one column in starting in J2 and ignore the blanks. I know this is an array formula, and can get one column to work with this...