max

Hi everyone, I thought this issue would be simple but it's actually proving to be quite difficult. I need to write a formula that will return the last balance for an account within a table of multiple accounts. Essentially the formula needs to look at the MAX date for all transactions...

Hi All, I am working on dashboard in which target based scores are being given. e.g Min & Max target for Calling - Minimum 60 call and Max >=70 calls per day Minimum score 0 and Maximum is 20%, Score will be proportionate where Achievement 61= Score will be 2% , Achv 62= Score 4% and so on...

Excel 2007 Column A contains dates in dd-mm-yyyy Column B contains values in numericals. Column C1 = Start Date 01-01-2019 Column C2 = End Date. 31-01-2019 A B 16-12-2018 7000 21-01-2019 10305 22-01-2019 9785 24-01-2019 11400 (> Max...

I have this setup: ``` date cost 22 march 2018 100 10 january 2018 20 15 march 2019 150 12 january 2019 133 ``` I don't know in advance, which cost, dates or how many rows I'll have. Need a measure that...

Hi I want to write a code (for learning purpose) asking user to enter 10 numbers or whatever user going to enter then the code will find the max number from these number and print a message saying "number ?? is the max you entered". Can that be done in VBA? Thank you very much.

Below is a sample of the data set (starting in cell A1) I am working with (the real set has many more rows & columns). I have a formula which will return me the Min value (-2.2) and the Max value (3.0). What I am trying to do is add a formula that will return me the location of where the Min...

Hi, I am looking for two different formulas which will calculate score in B & C column respectively, logic given in below table … Please help me build the formula … Formula 1. >1.25 = 0 Increase on each step 0.132% Max 10% at 2 Formula 2. <0.21% = 0 Increase on each step 0.25% Max 5% at...

https://www.photobox.co.uk/my/photo/full?photo_id=502027697277 I'm currently working on a project for an investment company to find how much money has been committed at any specified point in time. I'm using the array formula shown to find this amount. The next thing I want to do is find the...

Hello, Can you help me with this, I need to put in the result the max "320" https://docs.google.com/spreadsheets...it?usp=sharing

Hi All, Looking for min Max formula which will return following answer If A1 =<.4% Result (in B1) will be 0% & if A1=>.2% Result will be 5%. Please help me build this formula. Thanks & Regards, Sanket 7738414678

I want to apply conditional formatting to column M based on the wavelength in column G. I do not want to compare it to the actual wavelength but a criteria based on the different wavelength. So 1310 would have have max value of .4500, 1550 would have have a max value of .2500 and 1625 would have...

I have a formula worked out for financial auto loans but the only problem is I need it to cap out @ $900. I currently have a table set up where users enter the income (b22), rent (b23), monthly credit card debts (b24) and monthly insolvency debts (if any) (C32). It checks to see that it doesnt...

Thanks Dante Amor for your assistance with the rows query. This is a separate query regarding deleting columns once criteria is met, then stopping at a point. I have a variable named value "MAX" which can be between 1 & 12. 1 to 12 is numbered in 'E3' to 'P3' of the worksheet, 'A3' to 'D3'...

Hey All, I've been working his formula since yesterday and I've decided to break down and ask for some help. Excel keeps asking to correct the following formula: =MAX(F4*R4), ((((O4/MONTH(TODAY())))*12)*(F4)) to: MAX(F4*R4)*((((O4/MONTH(TODAY())))*12)*(F4)) I can't seem to get it right or...

ok this does not work but I'll post it so you can see what I'm trying to do, returns #REF "=IF(OR(W886="cp",W886="f",W886="m",W886="o",W886="of",W886="sf"),MAX(AH$5:ROW()-1)+1,"")" If you don't follow what that is trying to do... I keep track of mileage and expenses for a business vehicle...

to all I am trying to do a "double" search with Index & MATCH I want to return the value in the header (row 7) corresponding to the max value - See attached test I find the max value - cell c2 and find the ID corresponding to the max value (cell c3) using a match I know would like to return...

Hi, I am new here. The question I am asking may have a solution in a previous thread. If so, please share a link to it. Really appreciate it. <tbody> A B C D E F G 1 Date Cashier A Cashier B Cashier C Max 182 2 1-Jan 164 156 157 Cashier xx 3 2-Jan 182 159 158 Date yy 4 3-Jan 172...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> My data are in the column C:P, require results in the Column V:X</SPAN></SPAN> For example count max occurrences of the "last to first" character find in the each row</SPAN></SPAN> Row 6 last to first character "1" max occurrence=1, result In...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> My data are in the column C:P, require results in the Column R:T</SPAN></SPAN> For example count max occurrences of the 1st character find in the each row</SPAN></SPAN> Row 6 1st character X max occurrence=1, result In S6=1</SPAN></SPAN> Row 7...

I have a list of dates that are all text. Is there a way to find the largest and smallest date in the list without converting the text to numerical dates?