LinkBack URL
About LinkBacks
Good morning,
Can a table be referenced to another table so that it resizes when source table does?
As in the attachment, new data is added to SOURCE table in row8, DUPLICATE table should also expands to row8.....
Good morning,
Can a table be referenced to another table so that it resizes when source table does?
As in the attachment, new data is added to SOURCE table in row8, DUPLICATE table should also expands to row8.....
I doubt you can do it automatically with a second structured table. But you could do it with the new dynamic FILTER function.
Formula:
=FILTER(Source,Source[Name]<>"")
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or better:Formula:=LET(x,FILTER(Source,(Source[Name]<>"")+(Source[City]<>"")),IF(x="","",x))
How will I be able to have the output go into a table......I get SPILL error when I convert it
You can't.How will I be able to have the output go into a table
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks