Register
Log In
Unanswered
Home
New Member
December 22, 2016
Offline
Hi
I am looking for a formula, currently I can only think of using an if statement but I am not sure if it is the most practical. I am thinking ..if identifier is exact, put value from 1, and value from 2 and so.
The spreadsheet I have contains few columns but hundreds of rows.
Master - the first tab of the spreadsheet contains - an identifier (number), description, value1 and value 2 (4 columns)
sheet1 - summarizes a few identifiers from the master
sheet2 - summarizes a few identifiers from the master
sheet3 - summarizes a few identifiers from the master
I need to summarize identifiers on separate tabs within the same spreadsheet but need a formula that will capture changes if the original data is changed.
I hope I have explained this well enough....
Dashboards
Power BI
Power Query
April 21, 2015
Offline
As I understand it: The identifier is the unique key?
Then you can use probably the Vlookup on the summarize sheets, depending on which identifiers you want to summarize there.
Any change in the Master sheet is then followed on the summarize sheet.
But I'm afraid the information in your question is not complete? Please try to give an example file?
Online
Most Users Ever Online: 57
Currently Online: Mynda Treacy
13 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
