Hello Experts,
I am looking for a solution to combine 2 'live' trackers that get updated by 2 separate teams.
I have a "Team-A.xlsx" report which gets updated by 5 team members, hosted on a SharePoint.
In this spreadsheet, I 'mirror' few Columns (A,B,C,E,F & I) from 'BaseData-A' to 'Combined-AB'...
Hello Experts,
I have a project tracker in which each row is represents an on-going project.
There is one Col-'Status Update', in which team adds a note, starting with a date and in a single line, what happened on that day.
I am looking for a formula to extract the last 3 lines in a cell from...
Hello Experts,
I have a Pivot table created from a realtime data source in "Pviot_Data" tab.
Each row in the Pivot will have be in this format:
Text1-Num1-Text2-Text3
I am trying to extract:
1. Text1 & Text3 in 'Pivot_Data' tab into separate Columns in 'Extracted_Data' tab. (Done)
2. Need to...
Hello Experts,
First of all, I don't know if this is the right approach to ask for such a big help, where you folks do it for free. (as I understood).
I'd be happy to donate my bit, for all the amazing help you render here...
Anyway, below is the reason I am here:
Context:
Sales team reaches...
Thanks to you all Experts: Chihiro, John Jairo V & bocco_yip.
Really appreciate your quick responses & help.:)
Also, if you can suggest:
What's the best way to learn to construct such formulas & also step into VBA & Macros?
Thanks in advance
Sekhar
Hi Experts,
I am trying to do a Dashboard, where the source data is realtime from server, configurable as a pivot table in 'Data' tab.
I configured a pivot table, which looks like the one in 'Data' tab.
FYI - in attached, I just copy pasted values there, to re-create the data/format.
What I...
Thanks bosco_yip.
This works well.
The only edit I need is the formula in Col M-thru-S NOT considering zero(0) while calculating Averages.
Can you help?
Hello p45cal & Nightlytic.
Thanks a ton!!! for quick help.
Both are really helpful, but Nightlytic's formula based solution will be more appropriate to my need.
p45cal - As you pointed out, the count in Nyghtlytic's sheet doesn't include zeros, but the average takes them into account. This...
Hello Chandoo Community,
I am new to the forums & looking for help.
Background:
I have a spreadsheet attached in which
1. We are trying to identify 'Implementation Channel' for all our Customer & non-customer project effort.
This is a manual work in progress, some may never be identified...