LinkBack URL
About LinkBacks
column A of sheet "Sales Tax WV" is not updating, it has worked fine in previous years but now entire sheet is not updating, i suspect the issue is with column A.
column A of sheet "Sales Tax WV" is not updating, it has worked fine in previous years but now entire sheet is not updating, i suspect the issue is with column A.
This formula refers to A2:
=IF(SUMIFS(Revenue!$BN$5:$BN$1000,Revenue!$BL$5:$BL$1000,$A2,Revenue!$BK$5:$BK$1000,B$72)=0,"",SUMIFS(Revenue!$BN$5:$BN$1000,Revenue!$BL$5:$BL$1000,$A2,Revenue!$BK$5:$BK$1000,B$72))
A2 is empty ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Volunteer organiser & photographer with the Sutton Hoo Ship's Company: https://saxonship.org/
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
ok, i pasted formula up to A2 but column A is still not updating
column A should update with cities from revenue sheet
There is a Circular reference in cel A3
Please Login or Register to view this content.
Change A3 into A2
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Remove EVERYTHING from A2 to A30, then in A2 followed by ENTER:
=SORT(UNIQUE(TRIMRANGE(Revenue!I8:I5000)))
that works and is soo much cleaner... TY!
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.
Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
Pls try this formula
worksheet or tab name : Sales Tax WV
Cell A3 , drag down
Formula:
Please Login or Register to view this content.
365
Formula:Please Login or Register to view this content.
Last edited by wk9128; 04-27-2025 at 07:53 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks