formulas

Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...

Hi All, I want to dynamically link the entry in a cell to another formula - I tried using the indirect function, but cannot seem to get it to work. Is this possible - what I am trying to get in Cell B4 is the number 5, and not "2+3". When working correctly I should be able to change Cell C2 to...

Dear All, I would like to kindly ask for your assistance on a bottleneck that i am facing the last couple of weeks in excel and can't solve myself. I have attached a simplified version of my model just for illustration purposes in order to make it easier for someone that could assist me. So...

Hi all, I currently have this setup: I have a row of formulas saying IF(ISBLANK(cell below),return blank value, otherwise return value to the left + 7) to advance the week one week ahead when data is entered. I want to create a conditional formatting for this row, so whenever a value is...

Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...

Hi All, I am having an issue in Excel. My current setup looks like this: However, if I put range("O2") it works fine and it sends out the email to my email address. But once I try to increase the range and make it send out to multiple emails, it comes with the following error (highlighting...

Hi all, I’ve been struggling with this for some time because I need to use formulas to automate the new database column, not VBA or power query. Essentially what I want to do is create a column that combines two other columns but the difference is appended to the bottom. For ease of explanation...

Hi after a formula for conditional formatting In column A I have dropdowns where I select an item. Col B.C,D are amounts Col E is a final amount I want it so in Col E the formula is if Col A sees a word then when Col E is greater than 80 it will be green. If that makes sense :)

Hi there, I am currently using the following two measures with a power pivot table: Sales Count =DISTINCTCOUNT(SalesHistory[Transaction ID]) Sales Frequency (return a “2” if there are at least 3 sales instances, “1” if instances of sales is between 1-3, “0” if no sale) =if([Sales...

Hello, I have a simple data validation of each quarter in a year, C4. Once the quarter has been chosen it displays each month within that quarter in cells: F4,I4,& L4. Currently these months which are displayed are not in date format. How can I get them to be dates and not general text. Also...

I am trying to combine two formulas in excel, one to determine if a vendor is one of two options (the vendor number starts with M or not) and the other formula is to count the number of cells that are not blank. I basically need to count if a cell has data and then separate this into one of two...

Dear all, I am currently trying to return some data from a larger database. I have created a test sheet that is very similar to the real sheet that I am working with, for the sake of privacy and making things easier to understand from an outside perspective. Currently, I have the following...

Hello, Just wondering if any knows if / how this can be done in Google Sheets. 10 colums of data with 1,000 rows on a Google Sheets Document What forumula can I use to automatically insert one or more blank rows after every 100 data filled rows to break up the large block of data? Is there a...

Ok, so this is a follow-up to a previous thread which I thought I had solved and turns out I was just really tired and not paying attention to what I was doing. Apologies for re-introducing the question. I have 4 tabs worth of information: 1) Site information (Named table: T_Branches)...

Here's my spreadsheet. Objective: Get a [cumulative] Weighted Ranking of Plants by including only specific individuals' ranks for plant types. Disclaimers and needs to keep in mind: 1. No Visual Basic / Macros 2. I'm using Excel 2010, which means no FILTER, along with a few other functions...

Hi guys can you please help me in doing points: 1,2 and 3 of the assignment here below: (I also added below the excel file)

Good day, I'm having a struggle trying to figure out how to do something regarding DOW and Dates. For example, in the dataset I have Sunday, August 1s 2021 has the number 100 and I want to compare that against the first Sunday in August 2019, not against the 1st (date) itself because that is a...

I have one workbook. I have a data entry sheet where users can enter data (A3:H866) - vertical orientation. I also have a summary sheet (AB6:AM90) - horizontal orientation where I have used an Index formula to bring in values from the data entry sheets. The expectation is that if there is a...

I have a list of time off requests that are listed as date ranges (ie. 6/7/21 - 6/10/21 ) and I need to make a count of how many days off are requested for each date, ideally without having to manually input each date between the date ranges. So i want to be able to input 6/7/21 - 6/10/21...

Hi, I have lot currency conversion data that needs to be transposed so we can load it to a DB. Due to security restrictions no macros are allowed so I will have to rely on formulas. The existing data is in this format: DateYearQuarterAUDCAD CurncyAUDCLP CurncyAUDCZK Curncy...