If the value does not match, instead of being blank, skip to the next line

**hidden78731** · 03-24-2016, 11:00 AM

I have attached and example to make this easier to explain.

On the Measure Model tab, cell A2, enter application type from Data Dump tab if "Invoice Sent" is the value in column B on the Data Dump tab. If I create an If statement, then I get a lot of blank values in column A on the Measure Model tab, so I would like to figure out how to have it skip down the lines when the value in column B is not Invoice Sent and only enter the application type when it matches.

Does that make sense? Feel free to follow up with any questions. Thank you for your help, I appreciate it.

**newdoverman** · 03-24-2016, 11:43 AM

Enter this on the Measure Model worksheet in A2 and fill down and across. Enter with Ctrl + Shift + Enter

Formula:

Please Login or Register  to view this content.

View of partial results:

	A	B
1	Application Type
2	Prescriptive	Invoice Sent
3	Prescriptive	Invoice Sent
4	Prescriptive	Invoice Sent
5	Prescriptive	Invoice Sent
6	Prescriptive	Invoice Sent
7	Custom	Invoice Sent
8	Custom	Invoice Sent
9	Custom	Invoice Sent
10	Custom	Invoice Sent
11	Custom	Invoice Sent
12	Not custom	Invoice Sent
13	Not custom	Invoice Sent

**hidden78731** · 03-24-2016, 12:18 PM

OK, I tried that and I have attached the outcome. It didn't work as I had hope, I have now included an example of what I had anticipated.

Thank you!

**newdoverman** · 03-24-2016, 12:27 PM

Can't you use the formula that I gave you without filling across...only down? This would leave you with only the values in column A corresponding to Invoice Sent.

**hidden78731** · 03-24-2016, 03:20 PM

Thank you for your help!

If the value does not match, instead of being blank, skip to the next line

LinkBack

Thread Tools

Rate This Thread

Display

If the value does not match, instead of being blank, skip to the next line

Re: If the value does not match, instead of being blank, skip to the next line

Re: If the value does not match, instead of being blank, skip to the next line

Re: If the value does not match, instead of being blank, skip to the next line

Re: If the value does not match, instead of being blank, skip to the next line

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Go to right thru a range and skip all blank cells, return value of first non-blank in rang

[SOLVED] IF name match, copy, if blank skip to next row

# of blank labels to skip

[SOLVED] Need help : Conditional formatting border line with skip blank data

index match, ..... skip result if blank value ...... jump to next match

[SOLVED] match function to line up 3 possible results and skip every 3 rows

[SOLVED] How, on a line chart, to skip blank entry rather than plot as 0?

Bookmarks

Bookmarks

Posting Permissions