Doing multiple forumlas in excel

a sample workbook would help here, but I think you are looking for something like this (in A2):
=IF(COUNTIF($A$1:A1,'Incoming Attacks'!AY3)>0,"",AY3)
Drag down

Hope this helps

$A$1 should be blank (you could put a Column Header there, as long as it doesn't match any possible value from 'Incoming Attacks' AY range), it's used to avoid a circular reference error when you are checking for repeats in the list (the COUNTIF formula)

and you are welcome

Add a File - click advanced (next to quick post), scroll down until you see "manage attachments", click that and select "add files" (top right corner). click "select files" find your file, select file, click "upload",when the file shows up in bottom left click 'done" bottom right. click "submit reply"

Any way you can make a copy, then strip it down to what is needed to get the answer? even if some of the data is just hard copied..(ie- Copy, Paste Special, Values), would make it a lot easier to see what you expect, and why its not working the way you want!

You have me very intrigued with this one, and I really would like to find you a solution

Also...a few quick notes in the workbook about what you are hoping to see as the results would be a help

ok file is attached in a newer version.

I am wanting to contain information from a game I am playing. This information would be coords, ranks, items taken, who is attacked and who was attacked. This would also only contain the 1 person being attacked, or the one person attacking. After I figure this out I will go into figuring out more information about this game. But the whole spreadsheet is attached. Also if you click on the Attack Information spreadsheet you will see where the information I am messing with is contained. The incoming attacks tab I will be updating when attacks happen.

ok, now what sheet do you want this information on, and where ?
Also, does the date make a difference in whether it gets displayed or not?

ahhh...It Was my bad...forgot to include the sheet name on the final AY3 reference...try this:
=IF(COUNTIF($A$1:A1,'Incoming Attacks'!AY3)>0,"",'Incoming Attacks'!AY3)

Sorry about that, I should have caught that earlier

Okay, I found where you are...try this instead:
=IF(COUNTIF($V$2:V2,'Incoming Attacks'!AY3)>0,"",'Incoming Attacks'!AY3)

Hope that helps

Looking at your sheet, maybe what you are wanting is only the attacker with 1 incoming attack?
If so, try this one in V3:
=If(U3=1,T3,"")
copied down

You are very welcome !
If you need any more help, feel free to start another post, everyone here is more than willing to help

Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"

Originally Posted by BrianB77

Wow that did the trick...thank you very much for helping me figure this out. Now onto figuring out more complex things i can do with excel. This is really the first time I have done formulas with it.

Thanks again for your help.

If thats the response, it did show up, just on the second page, I didn't catch it because I was writing another response...lol

And no problems about being a new user of Excel..we all were at one time or another

Glad to see you are willing to learn, and not afraid to ask questions !
This forum (and MANY others, as well) has lots of things to teach/show/give, we all just have to be willing to look or ask