000

This is probably an easy solve, but I am a bit stumped and have tried using @if, @match type formulas and keep getting "N/A"... I have 2 tabs in excel. The first tab has over 15,000 rows of data. The 2nd tab has about 2,000 rows of data. I want to see if the account # in tab 1 is also on tab...

I am trying to write a formula that will look at a constant data point (C2) and return all values related to C2. In other words, list all items from a different spreadsheet that refer to John Doe Example: =IFERROR(VLOOKUP($C$2,'sheet1'l$B$2:$C$153,2,FALSE),"") For the first cell, it returns...

Hello! In need of assistance to build functional tool to help sales agents track monthly commissions. The commission rate is applied to monthly sales and the rate increases as accumulated annual sales reach specified thresholds. I'm having trouble entering formulas in the "Monthly Incentive"...

I just want to do a color formatting for regional sales in column B (from B2 to B8) using the value in cell A1 and add the total number of the same color/Region in E column (E2 to E5). Desired Result <tbody> A1 B1 D1 E1...

Hello, This is my first thread so ill hope you have some understanding :) Anyways, I have this issue which I don't manage to solve. I've obtained some information in a spread sheet and it is structured like this: [Column 1] Column 2 [Information 1] 1,000 [Information 2] 2,000 [Information 3]...

Hello, I am trying to get automated text (highlighted in color red) based on the selected range and need solution in cells which says Total (Apr-Dec) and Total (Feb-Nov). This label should be based on corresponding month where 1st value in counter row is 1 and corresponding month where last...

How do I tweak this UDF further to get it to give me the output I need Function Decompose(ByVal Number As String) As String Dim X As Long Number = Replace(Number, ",", "") If Number = 0 Then Decompose = "0 ones" Else For X = Len(Number) To 1 Step -1 If Mid(Number, X, 1)...

Extract Acrobatics = Looking for a modification to extractformula that will order records in date ascending order AND then by dollaramount lowest to highest. So, recordswould in this case be in the following order by Person. Person3 Person8 Person5 Person2 Person4 Can this be done...

Hi, I need some help with Excel to calculate ROI for this situation: <tbody> date quantity price bought quantity price sold ROI 2015-09-05 4,000 3.16 2015-11-05 1,500 3.56 2016-07-08 2,000 4.13 2016-11-10 2,000 4.51 2017-01-05 1,000 4.12...

I have made a worksheet based on another excel file which was prepared by a Thai gentleman.The file by this gentleman is FIFOComplete.xls. The other is my file. In my file FIFO does'nt work after the second entry for out is made. The Data Table in this file FIFOComplete is in Range R5:Q15 which...

I am looking for help figuring out a formula that will calculate the following: <tbody> Range Bonus (per million) $7 Million - $16 Million $5,000 $17 Million - $27 Million $2,500 $28 Million + $1,000 </tbody> Thank you!

Hi, Had a real disaster trying to analyse some data, I think I'm missing something basic I never learned. The data Looked like it had been lifted from a pivot table. The title first row had company, territory, product and then Jan-17- Jul 18 as columns. When I tried to build a pivot, as...

Hello, I have a huge spreadsheet that I am trying to do a summary on. I thought using a SUMIFS formula would work but I just can't seem to get the correct formula, I keep getting ERROR messages. Any help would be greatly appreciated. Please see structure below. <tbody> Current Spreadsheet...

I am having issues creating this formula for a Projected Cash Flow Budget regarding the Commission Sales Payout. Here is the scenario as followed: The first $200,000 = 10% The second $200,000 = 8% Any sales dollar exceeding $400,000 = 7% Lets say our Sales guy sales $280,000 the first month...

Hello fellow members, I have a question with regards to average that need your kind assistance. If average for 3 stations in first 9 months is $ 980,000 and average for 4 stations in last 3 months is $ 1,020,000. What is the average sales per station in current year ? Thanks.

I have 3 tables, can put these three parameters together in one chart or graph? Please help!! <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Age-group 18-23 50 24-29 78 30-35 31 </tbody> <colgroup><col width="64" span="2"...

So we have bank statements that come in and we are trying to organize everything from example A to look like example B. To do this, we need to have a formula that takes into account the date, to put it in the correct month, as well as listing it under the correct subcategory. What would the...

I'm sure that I'm over complicating. Essentially I need to calculate the amount per journey where the amount is $0.45 per mile for the first 10,000 and $0.25 thereafter. My formula works fine up to 10,000 and for the journey that crosses the threshold but not for amounts over 10,000...

Hi everyone! Have a question which I've been struggling with for a while today. I'll try and keep this short. Not asking anyone to write the formula for me, just point me in the right direction if possible. (A) I have a target bonus payment totaling $50,000. (B) I have a sales target of...

Everything I input into Solver is giving me a not feasible solution. How should I be setting up a linear regression to find optimal production with the following data? I'm also unsure of how to add a promotion, any tips? <colgroup><col width="157" style="width: 118pt;"><col width="65"...