excel formula

Hi, Can anybody help me with the formula for the following: I need sort of a running count: Column A is the combination of the 1) the competition number and 2) the player number. For each new competition number, I would like to have a new running count that start again at 1. And for each new...

Hey guys! I would like to create a formula that counts the unique values in column G of the TB_incident_task tab with the formula below, which is my current formula. =SUMPRODUCT((TB_incident_task!$E$2:$E$8571=Dashboard!C14) * (TB_incident_task!$K$2:$K$8571=Dashboard!$B$5)) I tried to...

Hi - I have an excel sheet which has numerical data in columns J through AV. I would like to highlight rows where all columns have data as either 0 or blank. How do I achieve it through either conditional formatting or formula? Example below - (In this, I would like to highlight row 2). Thanks...

Hello, I need help with an excel formula that will auto populate the column PRIORITY LEVEL based on columns CRITICALITY and FREQUENCY LEVEL (see attached screenshot of what should be populated in PRIORITY LEVEL column). I know that this can be done using IF function, but I can't seem to find...

I am working on making some updates to a training tracker and am having trouble pulling out just the numbers to make adding a score to responses automatic. The possible answers we can get back range from 1-5 and have a letter with it. There can be multiple answers provided for each column. When...

HI Masters, I need help in getting the invoice number in a cell with a text string. ABC1SUPPLIERDETAILSINVOICE#2ABC COINV#: 66042262 - 522.00 INV#: 66042335 - 960.00 Tools66042262 664023353ABC COINV#: 66038272 Pvc 660382724ABC COINV#: 6602869366028693 Thanks, Lay

I've created a dynamic range formula which shows as below: =CONCATENATE("AC SalesRawData!",SUBSTITUTE(ADDRESS(1,C1,4),"1",""),":",SUBSTITUTE(ADDRESS(1,C2,4),"1","")) Which gives me the range output "AC SalesRawData!CQ:DS" I'm then referencing this range in an vlookup using Indirect as shown...

Hello, this one is really hearting my head. Could any one help me with a formula to count unique names per month in the table below? Data will be added constantly to the table so it would need to count the whole column instead of just a fixed range. The results would show 2 on cell J2, 1 on cell...

Hi, Just wondering if anyone could give me a hand with this excel formula please? I’m trying to pick up the Total Team A balance (TeamA_red + TeamA_yellow + TeamA_pink), the expected total is $960. I’ll need a wildcard to pick up any columns with a “TeamA” description. I’ve tried using index...

Hi Friends, I wrote a simple single-line coding to bring the C2 value to D2 in Excel VBA. ThisWorkbook.Sheets("MM_Input").Range("D2:D2") = "=C2" After I executed the above code I noticed a weird result in cell D2 like the one below, I do not understand why the plus symbol automatically gets...

I have tried all that I could find on this site. What I am trying to do is Sumif the colums: Column E,Owner, uses dropdown Coumn F is the the amount paid: =IF(E20="Ian","$.50","") Column G,Payment,I want to total all of Column F: I have: =sumproduct(sumif($E2:$E49,"-ian",$F2:$F49)) also have...

Hi I need some help and I hope I am explaining this correctly, I have attached a photo of my spreadsheet and I need to increase the value of column (M) so that each value has a minimum profit of 2.50 Column (M) is determined by column (I) so I need something that will adjust column (I) until...

Hello, Hoping someone can assist me with this excel question. I would like to create List3 as it looks. If the color in List2 is in List1, then I want it to show up in List3. The part I am stuck on is getting List3 to pull green to the first row,, blue to the second row, and so on. Appreciate...

Hi, I have a tab that has user and their status in 1 tab of raw data, and a final status in another tab. The raw data has multiple entries for the user AND status. How do I match all the entries, and figure out the (final) user status? The user status can be Active, Inactive, or Decertified...

Excel experts!! I need you help... I have a long list of names that I want to copy over to another sheet, however, I want the names to be in every other row on the other sheet. Is there a way to do this with a formula, as the list will continue to grow and I want the other sheet to...

I have below values in cells A1 and B1. A1: 118999.26 B1: 118231.21 values in A1 and B1 are pasted and each contains 2 decimals only. In the cell C1, when I apply formula "A1-B1", and increase decimals, it is giving me the answer as "768.050000000003" Where is the last 3 coming from in the...

Does anyone know how to make a sequence of number as follows: Start between 1 & 15, increment either in 5 or 10 but always ending at 100? For example Start at 5 and increment in 10s: 5,15,25,35,45,55,65,75,85,95,100 For some sequences it's easy starting at 5 and incrementing in 5s as it can...

Hey, i need some help with the SUMIF formula. i got a sheet with product material numbers and i want to lookup the material numbers in a sales sheet. Example: The picture is from the sales sheet and lets say i want to look up "material nr 1" in the other sheet and criteria to be material nr 1...

Hi there, I was given the task to force balance the data in 'Q1_2024_Raw' to sum to the final total by GEO (i.e. all LATAM customers need to sum to 10, so in this case I need to force balance their data down from 20 to 10 and all NAAM customers need to sum to 100 so I need to force balance up...

I have a formula that works but need to put a twist on it to look at another column / Sheet. {=IF(ROWS(E$5:E5)<=$B$8,INDEX(INDIRECT(E$4),SMALL(IF(Date_Received=$A$8,ROW(Date_Received)-ROW(AuditLog!$B$2)+1),ROWS(E$5:E5))),"")} This is working. I need to add this to it...