indirect

I have a supplier who decided to populate data in a complex way thus making life a bit difficult in working with a form. Item are placed like the below table.. this is just 1/8 of contents. I need to lookup in this sheet find the supplier code which is in either column A, C, E or G then return...

Hi All, I am currently working on a large data set. I took the 10 largest values within this data set using the large formula. After this I wanted the area these values came from and found this formula online, =INDIRECT(ADDRESS(1,SUMPRODUCT((B1:M9=A13)*COLUMN(B1:M1)))). It seemed to work but...

Hi all, trying to sum up across multiple sheets. Caveat: the cells being added up are all the same cell address as the active cell, just on different sheets. My troubles: I'd like to be able to insert rows or columns across all tabs and have the formula adjust to always be summing the equivalent...

I have a column of sheet tab names in Column A. I would like Column B to reference cell G44 in each corresponding sheet tab. This is the code I am using. However, it is giving me a reference error. Does anyone have any idea what I am doing wrong? =INDIRECT((SUBSTITUTE(TRIM(A6),"...

Column F: i have used drop-down list and below code to get two values in one cell, >>>>>>> Private Sub Worksheet_Change(ByVal Target As Range) 'Updated by Extendoffice 2019/11/13 Dim xRng As Range Dim xValue1 As String Dim xValue2 As String If Target.Count > 1 Then Exit Sub...

Hi guyz, Please excuse me if this question has already been asked multiple times. I am very bad with the VBA Scripting and would appreciate any and all help with my query here. So, what do I need help with? I have a folder in my C:\ Drive with the name "Acc". In this folder I have Multiple...

Hello, I am trying to use COUNTIFS and INDIRECT but my formula is not working. I have different sheets, and each sheet represents a store location. In each sheet, there is a Sales Person name and the sales amount generated for each store item (e.g., shoes, tops, dresses). In my summary sheet...

Hi guys! I have a column that I need to color with conditional formatting based on two different criteria. I am using the following formula in the conditional formatting pain and it does work: =AND(AC2="Yes", AK2=INDIRECT("Partners!B6")) The issue is I need the range of Partners!B6:B not just...

Hello, I have a question and i hope someone can help me out. I want to use the indirect function. I already used it in F1. I did =VLOOKUP(E1,INDIRECT(D1),2,0) Now I want to do it the same way in F3 but now with sumifs or maybe another function? I actually want a value of 18 in F3. How can I do...

Hi, I am attempting to use two countif conditions across multiple sheets (which I have named "Tabs" in name manager) to count how many times a job is raised for an item with a certain reference number in a particular year of its ownership. I have used a no. of forum posts to get me to where I...

Hello all! I have spent many hours attempting to solve this problem and hope one of the geniuses on this forum could please help! I think I am doing something simple wrong, and it might just take a quick lookover. I have a monthly task where I need to take my employer's budget from their...

I have a Excel table in the form below that was extracted from a separate sheet: Level1 Level1-Level2 Level2 Level2-Level3 Level3 Level3-Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild...

I have a excel table in the form below: Level1 Level1- Level2 Level2 Level2- Level3 Level3 Level3- Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild records and so on... Level1-Level2 is...

Hi Guys I have read a lot of threads on this, but it seems to be one thing which is a mammoth struggle in Excel. The challenge: I need to produce a MASTER Resource Plan, which will consolidate individual team members planning into one overview. The source workbooks are all consistently...

I've been tinkering for a while, but just can't seem to get this to work as desired. I have multiple tables in a workbook: TblFuel TblVehicles TblPlant_Machinery TblMaterials TblLabour I'm creating a quote page where the initial selection is for one of these item types(Fuel, Vehicle...

Hello, I have data like this: Color Shape One Circle Two Red Three Square Two Three What I'm doing is returning the value in column A in the last non blank row in column B regardless of the value. Currently, in cell B5, I am using...

In the column named Example it should show the time different between every status change and when the when status is CLOSE I want to do a time different between status NEW and status CLOSE. Hope you guys have some great answer to this question. :) Best Regards Ahlis

Hi, Not super familiar with the platform, but trying my best. This instance is referring to google sheets, but excel and sheets seem to be pretty similar. I am trying to reference data from multiple sheets into a master summary sheet. I started with just referencing the sheets and the cell...

Hello, I'm calculating Split Multiplier column from Split Ratio column by multiplying the rows from the current row towards the end of the column. It works nicely within normal excel table with PRODUCT($B3:INDEX(B:B; ROWS($B$3#)+ROW($B$3)-1) ) where the formula is copied down, but if I try to...

The formula I'm having trouble with on sheet1 It does the following... 1. Pulls the year from cell A1 2. Row 6 (column headers) has each month listed representing each month (M6:X6) 3. Column I represents sheet names. In the example below, the sheet name in I7 is "sheet2" Sheet2 is an...