Compare Column Values (Including Blanks)

**airj1012** · 03-06-2018, 03:29 PM

All,

I'm trying to compare the values within the cells of a row, disregarding the blanks, to see if the values are all the same.

Attached are the results I'm looking for.

Any thoughts on solutions?

Thanks.

**jeffreybrown** · 03-06-2018, 04:39 PM

How about in H2 copied down...

=IF(COUNTA(B2:G2)=COUNTIF(B2:G2,INDEX(B2:G2,MATCH("*",B2:G2,0))),"Yes","No")

**airj1012** · 03-06-2018, 05:31 PM

Great, thanks!

**jeffreybrown** · 03-06-2018, 06:14 PM

You are very welcome. Glad it worked for you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**FlameRetired** · 03-06-2018, 06:26 PM

An afterthought.

Formula:

Please Login or Register  to view this content.

Compare Column Values (Including Blanks)

LinkBack

Thread Tools

Rate This Thread

Display

Compare Column Values (Including Blanks)

Re: Compare Column Values (Including Blanks)

Re: Compare Column Values (Including Blanks)

Re: Compare Column Values (Including Blanks)

Re: Compare Column Values (Including Blanks)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] SUMIFS pulling all values including blanks

[SOLVED] Need to compare multiple values including TIME between, and compare rate

[SOLVED] Standard Deviation for Last "n" values in a column not including blanks

[SOLVED] Linking Returns for Last "n" values in a column not including blanks

[SOLVED] Rolling/Moving Average: Last "n" values not including blanks in a row

compare two columns and make 3rd column with no blanks

Returning values from a list including blanks

Bookmarks

Bookmarks

Posting Permissions