excel & formula

I am struggling in creating formulas that allows me to build the following table. The formulas that I need to create should be on the cells highlighted in orange. Specifically, given: The number of employees on staff each month, i.e. “employees on staff” The number of “new tasks assigned”...

I have this simple sheet and I want to return the band that the lookup value falls into. In this example I would expect the band to be returned to be "I" because 135 falls in the range of 130 to 139.99 I just can't figure out what formula to use, I tried a variation of lookup and index match...

Good After Noon, Trust everyone is Good Preparing a small tool which helps me in Daily routine at my work. I have a data where i am creating a pivot table and need to report out the numbers to my Team where we stand. I have written a code so far where pivot table is getting populated with the...

Hi any remedy to make my excel faster? This is some sample of my excel formulas =xlookup = b5&c2, NAME&DATE, LEAVE,"") =xlookup = b6&c2, NAME&DATE, LEAVE,"") =xlookup = b7&c2, NAME&DATE, LEAVE,"") =xlookup = b8&c2, NAME&DATE, LEAVE,"") Then drag the formula until =xlookup = b55&c2...

Hi please help me for this VBA code. Sheet 1 is leave planner Sheet 2 is Data (name &date&leave) are all in there The native excel formula is =xlookup = b5&c2, NAME&DATE, LEAVE,"") And then drag it until =xlookup = b5&AG2, NAME&DATE, LEAVE,"") And also drag it down from =xlookup = b5&c2...

Hi all, I have built a report with some financial transactions checking. The scenario is, (col A) company "1" sends money to (col B) company "2" so the common value in column C will be "12" (cell A & cell B). But if the company "2" sends money to "1" then in column C we will have "21". What...

I am trying to make an excel file for my parents so that they have it easier than writing all the info in a book X amount of times. i have A; B; C; D; E; F; G; H; I; J; and L columns and want to automate and duplicate the data in A to G in rows below xn-1 times when there is a number on Hx...

I'm pretty sure that there are lots of threads on this, but all of the threads that I have read through I can't get the formulas to translate to what I'm trying to do for some reason. I'm still really new to all of this and I've watched countless videos and I just can't get it. What I'm trying...

Hi, looking to get help for this issue I have that I can't figure out. I'm a newbie on Excel formulas So I have columns that need to yield 1 or blank based on separate columns that are in-between texts. The requirements are; IF Column's A, C, E, G, L, N (number columns) has one entry that...

Hello everyone! I want help for merging rows in excel. Below is attached picture having three columns first column is date, second column description and 3rd column amount. You can see after date there are some blanks rows but description don't have blanks. Solution! I want to merge every...

Hi, I would like to optimise my excel spreadsheet Is there a scrips to in one Column according to the name selected from a drop down box an email would automatically be generated and sent to the relevant persons after saving the document (data changed, email trigger to the selected individuals)...

I HAVE A $3,00,000/- OF AMOUNT AND ₹ 3,00,000.00 if Taxable amt fall in below range then remaining Balance mean only that amount fall in this range is taxable of 5% I want this amount 5% ₹ 2,50,001 ₹ 5,00,000 ₹ 49,999 ₹ 2,499.95 Multiply by 5%...

Hi again, As I showed in the image, I have to find 2 numbers right of "L". I have tried this formula,=RIGHT(Data1!J2,2) but I cannot apply other cells. What should I do? I will be waiting for your advice.

Can someone help me edit this formula to not return FALSE if criteria not met? =IF(C24="No",IF(G9>=250000,(((G9-100000)/1000)*5)+575),IF(C24="Yes",IF(G9>=250000,((((G9-100000)/1000)*5)+575),""))) I can't seem to get the syntax correct :(

Hi, I came across a similar thread VBA to copy range data with all visible and invisible cells to another sheet on MrExcel.com and was hoping to get some assistance on my scenario which is as follows: What I have on a tab (name: origin) Station People Cars A 12 29 B 6 10 C 4 2 TBC...

( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"

I have a formula =IF($A2="","",VLOOKUP($C2,$R:$S2)) The problem is, it does not recognize 2313A and returns a lookup of 123 instead And 456 returns a lookup of 2313A Why is it doing this? Spent days looking at this and can not figure out why. The lookup list is something like this : Columns R...

I have quite few 100's rows in my excel, which needs to be added with below formula and dragged across down. I have tried SEQUENCE formula with no luck. =CONCAT("<execute order="&TEXT(CHAR(34)&SEQUENCE(1,1,1,1)&CHAR(34),"Text"),"MR") This will return below <rule order="1"MR Now, for...

How to sum the total for 1(1A) + 3(3A) + 5 = 9(4A) ? other examples: 1(1A) + 3(2A) = 4(3A) 10(2A) + 1 = 11(2A) I need to sum at least 100 cells in the Excel (same column or same row). Thank you.