Pulling specific rows from a data set

**ExMAN999** · 10-29-2011, 01:21 PM

Hi everyone, I am new face on this forum and I have a problem. Would like to have some help

I attached a file with explanation and examples, hope it is easy to understand :D

**JBeaucaire** · 10-29-2011, 01:44 PM

You should EDIT that post above and do a better job with the title and the question, as per forum rules.

"Pulling specific rows from a data set"

"How to get certain rows from a database to appear in a shorter report?"

Here's one of many ways to do that...

**ExMAN999** · 10-29-2011, 03:40 PM

Originally Posted by JBeaucaire

You should EDIT that post above and do a better job with the title and the question, as per forum rules.

"Pulling specific rows from a data set"

"How to get certain rows from a database to appear in a shorter report?"

Here's one of many ways to do that...

Sorry, I've made it as needed now. Thank you a lot for your help. I have tried to make the same for my document, with a bigger number of words, and failed

Maybe you can give me a hand with original file?

I am so glad you understand what I want

tia

**JBeaucaire** · 10-29-2011, 04:00 PM

Originally Posted by JBeaucaire

You should EDIT that post above and do a better job with the title and the question, as per forum rules.

"Pulling specific rows from a data set"

"How to get certain rows from a database to appear in a shorter report?"

can you take care of that post #1 first please, as requested?

The fix is an easy one, I'll post it up after you fix that post, thanks.

**JBeaucaire** · 10-29-2011, 04:04 PM

My apologies, I see post #1 is fixed. Change your G1 formula to this:

=IF(A1=Specialcheck!$A$1, 1, 0)

**dangelor** · 10-29-2011, 05:13 PM

Try changing the formula in column G to

=IF(A2=Specialcheck!$A$1, SUM(G1,1), G1)

**ExMAN999** · 10-29-2011, 05:22 PM

Originally Posted by JBeaucaire

My apologies, I see post #1 is fixed. Change your G1 formula to this:

=IF(A1=Specialcheck!$A$1, 1, 0)

I just want to thank you again! You helped me a lot

**JBeaucaire** · 10-29-2011, 05:55 PM

Glad to help.

NOTE: Twice in this thread you quoted my entire post into yours, you shouldn't do that, makes your thread look messy. Just use the QUICK REPLY button or box below.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.