Another skip if false question

You need to look at the structure of the IF function.

Formula:

=IF("condition", "result if condition is TRUE", "result if condition is FALSE")

You only have the result if condition is TRUE" part. Hence if the condition is not met, you just get FALSE rather than an output of your choosing.


Regards, TMS

The OP has a formula that either references desired data from another sheet, or shows FALSE. What he wants to do is to compress out the FALSE results so the destination just shows the desired data. (The fact that the result itself is FALSE is not the problem.)

I see that you have posted to a VBA forum but have no VBA in your file and have not asked for a VBA solution. I have attached a solution that requires no VBA but does add a "helper" column in column G of "Total Page".

You need to define what you want in the Month column of "Total Page". For example, for January the month should always be January so why do you need a column to show that for every transaction? I think you don't need this column at all.

As for your date question, the solution for that is quite straightforward but what date do you need to consider? Submission Date or Issue Date? (Your column K doesn't really match your date data. Some rows have a Month shown but the dates are blank.)

If you want a VBA solution then that is a different task, and I am more inclined to help solve problems in VBA solutions than to develop them from scratch.

The OP has a formula that either references desired data from another sheet, or shows FALSE. What he wants to do is to compress out the FALSE results so the destination just shows the desired data. (The fact that the result itself is FALSE is not the problem.)

Not sure who this is addressed to or what is meant. The IF formula is not complete. I was suggesting that the OP looks at the structure of an IF function and add whatever the FALSE part of it needs to be. I could have suggested

Formula:

=IF('Policy Input'!K2= "JAN", 'Policy Input'!A2, "")

but that may not be what is required.

Regards, TMS

Hi 6StringJazzer and TMS,

Thank you so much for the Input.

To TMS's question:

The third part was intentionally left out b/c I tried "-", "", neither returned to my desired action. So I wanted to see if it will omit the answers that returned false if I just don't put anything, apparently it will return false.

To Jazzer:
Your interpretation was totally correct! And sorry for posting in the wrong section since I am not as inclined to an VBA solution due to the lack of my background knowledge. '

The "Month" column in "Total Page" was originally designed as a helper where it will copy all the entry from the "Month" column locates in "Policy Input" sheet.
Then the first column in "Total" sheet will copy all entries which passed logical test where it will copy name/policy/all that if the logical test for Jan return true.
But all charts for different month in "Total Page" sheet will have all the entries because those returned false will be transferred as well, hence the obstacle I was inquiring in OP.

In addition, I would love to go by Issue date for specific date range criteria.


Some additional info I think would help clarify the problem I am facing:

I was creating this excel for my boss and he wants to have a big excel spreadsheet where he can input all the policy and related information for record keeping. And because we are kind of a marketing firm and have different monthly promotion sent out (often based on the face amount of the written policy), so he wants the spreadsheet to be able to track policies by the writing agent or by the time frame (b/c every month we send out different promotion I guess), or whichever other way he wants it (this part I don't see big issue, just filter and advance filter).

Further, because every month the promotion eligible criteria is different and he wants the spread sheet to automatically judge if any policy/agent is eligible for the promotion of that month/quarter/year, also he wants it to evolve and be tailored as the business keep going over a long course.

Current structure is my optimal attempt so far with my very limited knowledge. If anyone feel like to chime in and is willing to shed some light in my immature project - deeply appreciated!


Sorry for the ramble lol.

Cheers!