I am attempting to assemble a spreadsheet which will add player stats from a football match, from 2 different tables into 1.
The tables are organised so that the playername is at the start of the row and the various starts follow it up. My issue with the formula is that certain players don't record any stats in a game and thus will not appear in one table but may appear in another.
What formula would i be able to use, adding stats, based on the name at the start of the row?
thanks
Plz post a sample file along with the desired result
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
sample+desired result.xlsx
the desired result is within the file. Thankyou
Plz see the attachment
Thankyou so much!!
If I wish to use this formula for other tables, which you be able to direct me to a link etc which would explain what to edit/explain it yourself
OK
Glad it help u.
If the answer helped u plz click on the * to add to my reputation.
how would i edit the formula so it will include stats for a player who appears only in one table?
The formula that i have put will fetch data from both the table. If a player is in only one table the formula will fetch that data only
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks