sense

Hi I would like a formula that allocates 10 point to highest bidder, the second bidder get proportion of the 10 point as distance from the highest bidder, so same from bidder 3 etc. Hope the above makes sense Any help would be much appreciated Thank you

hello Gentlepeople I have been given workbooks that are use more memory than makes sense. All are data; no formulas. the smallest is a xlsx file of 173MB. 91308 rows, 35 Columns If I make a file with the same number of rows and columns, the file size is 8.76MB copying and pasting values in...

Hi I have a table of data (D4:AI29). Row 4 is a header row that contains the numbers 1 - 32. In each row below the header, the letter "S" appears. I'm looking for a formula I can place in AK5 that will tell me the number in the header row that corresponds to where the S is in that row. I...

Hi Can you help with the formula that I would need to count the number of occurances there are in columns A, B and C but only if the data in column D for that row is 15 or 30 (I hope that makes sense!) <tbody> A B C D 3 3 3 15 3 30 3 3 3 3 </tbody> Many thanks :)

HI What I am trying to do is a lookup using 3 dates. <colgroup><col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2925;width:60pt" width="80"> </colgroup><tbody> Date Part 1/8/18 2287...

Hi Any help greatly appreciated before my head hits the desk.. I need a formula that says IF L3 is greater than 1 but less than D4, "ADVISORY" but if L3 is greater than D4, "FAIL". Additionally, if L3 is less than D4 but d2 is greater than f2, "ADVISORY" otherwise "PASS" I hope that makes...

Is there any w/ay to write a VLOOKUP that will return the value in a specific column that is identified by a letter instead of the number of cells from a refrence point? I hope my quiestion makes sense. I had a diffifuclt time trying to come up with the correct words EXAMPLE: CURRENT...

Hi, At work, we have access to certain folders depending on our job role. Currently one of my monthly jobs is to enter data into a workbook from another workbook - a direct copying process that I would love to automate to free me up to do the rest of my job! But the workbook that I'm updating...

VBA is iterating a spreadsheet and I would like VBA to sense if the a cell is hidden

I am trying to count the number of M's listed in four sections of a sheet but it will only return the value of 0 no matter what I put in the cells. Does anyone know why it does this because it doesn't make sense. Example: =COUNTIFS(A1:C1,"M",A2:C2,"M")

Currently, I have the following formula which is working perfectly... =INDEX('Sheet2'!A:CG,MATCH($A$89,'Sheet2!$C:$C,0),MATCH('Sheet1 '!$G$89,'Std Values'!1:1,0) Now the only problem, is if the output from this above formula returns zero, I would need the next value in that particular row...

Hi I am trying to use rank but it does not make sense how rank() function is ranking numbers. in the example below. why for example 96332 and 96103 both have rank #1 !! should not be rank 1 and 2 respectively? thanks ps: the function i wrote is =RANK(B2,B2:B25) then autofilled <tbody> salary...

I've been fiddling with this for hours and can't make sense of it so figured I'd ask for suggestions. I'm trying to work out a formula in column C that will display select values from column A as pictured below. I'd like it to do this only if there is more than one occurrence of a value in...

Good morning all, Hopefully someone can help me :) I have a range of data in Column B and I will paste in more data into column E. What I want to do is match any data in column E with the data in Column B. Does that make sense? So If in column E we have "4996", I want to match it if there is...

I need to add together the SUMPRODUCT from 5 sheets. I have tried a few things (,, --,+,AND, repeating SUMPRODUCT). This is what makes most sense to me, but it does not work...

Trying to find a formula to add two different types of widgets. The two widgets are in separate columns. When the two widgets are combined, they form a single part count as 1 item. I hope that this makes sense.

Hi everyone, First post. Be kind. Not sure the title makes sense or does my question any justice. Basically, I have a team tracker for my business and want it to feed directly into a feedback form I've created. It does that nicely using a simple vlookup formula. Perfect. However, I need it...

Can someone help me combine an indirect with an index/match. Here is my index/match formula: =INDEX('2017'!H5:S16,MATCH(B9,'2017'!B5:B18,0),MATCH(C4,'2017'!H4:S4,0)) This works perfectly. Obviously it is referencing data in a 2017 tab. But if the date in c4 is a 2018 date, I need it to...

So I am trying to strikethrough a cell in SheetA if there is anywhere on SheetB that the same word has been conditionally formatted to strikethrough. Make sense? :)

Hello - I was wondering if I could get extra eyes/minds to the following post I created at OzGrid.com. Would greatly appreciated. I would explain but it would make more sense to visit the following link. Please advise if this post is in violation of any Mr.Excel rules. Thank you...