In this photo the left is a predefined structure where all level 4's rollup to their above level 3's, and so on to level one. For example every sunflower is a flower and every flower is a plant... not a tree. Well on the right is a rollup/mapping table where we go as detailed as possible with...
I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query.
I want to import data into this pivot table (not using power query below):
I have the source data saved here:
So questionnaire data file 1 is week...
I currently have a sheet that looks like this:
(Please note that I have divided my excel file into two windows, so you can see both sheets at the same time).
I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my...
I currently have this code:
However, it seems that me highlighting it with bold and underlining it through the use of "<b><u>" (which has worked for me before), does not work anymore.
Does anybody have any idea how I can either fix or change my code?
It would be greatly...
I currently have something similar to this:
Linking to this:
It should return the date 21-06-2019 for XG10, but it does not.
Can anybody see what I did wrong and how to fix it?
Would be greatly appreciated! :)
10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated.
See attached spreadsheet....
I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green)
In row 71 and 72 (in yellow), I would like to...
New member here.
I have a spreadsheet with the below format. So a single workbook would have 90-100 sheets with that same format.
What I want to do is to collate all the data that match 4 criterias in a single workbook: Date, Oversees Manager, Overall Status, Assigned Contractor.
Please help me how to align data in different columns. Please see below raw data given.
C-1 C-2 C-3
-Given the sample above. Can you please help me what would be the formula on this? Because, i'm having...
I have an estimating spreadsheet that we use to estimate jobs. There are 80 sheets, all identical.
The sheets can be quite long, and to prevent scrolling, I froze the top row, and added some hyperlinks (using the formula =hyperlink). The links I have are Top, Materials, Labor, Summary...
i have a fairly simple problem with what i think is a pretty hard solution (at least to me)
so i have a sales comission report and need to pull agent totals to another excel file.
Seems pretty straight forward.... Except this report creates a new row per sale... so the totals row...
Hello: The following codes finds the last row in a table and then creates a simple numerical index starting with 1. A couple of things:
==> Is there a way to refer to column C without hard coding it so I can add and remove columns without a problem?
==> Is there a way to refer to cell C7...
I am working on a project where I have to reference different tabs of many rounds. I have formatted my index and match searches for the first round, but found that I was doing a lot of hard coding when trying to change each of the formulas for the "Round 2" tab.
Is there a way that I can...
Hi, good day!
Just need help in getting VBA code for this:
I want to add value to a certain cell hard coded in another sheet. To determine that particular cell need to check data on D5 and data on D10.
I have read here: https://professor-excel.com/performance-excel-study/ that INDEX/MATCH or VLOOKUPS can be up to 50% faster than SUMIFS but for some reason I am having a hard time replacing a SUMIF formula with either Index/Match or Vlookup. Has anyone done this in the past...
Hi friends, :biggrin:
I have to create a macro (or a formula) to do the following:
I need to get the supplier name when it appears on the below cell and transport to the same cell of the part number, adding new columns for them.
Column A --> is a structure index (not really important here)...
I was watching a video from CFI and then downloaded cash flow model. In the video they said that, hard coded numbers are in blue and cells which have formula/function are in black. That kind of formatting followed by all financial models.
My question, did they hard format that? I mean...
I have a spreadsheet that I need help writing the correct VBA code to allow for a cell containing a formula to be overwritten with hard coded data. To explain I have a cell that calculates a date however from time to time I need to override that calculated date with a hard coded date. The two...