I currently have this which finds the minumum but excludes zeros

{=MIN(IF(M38:M44>0,M38:M44))}

What I think I need but it doesn’t work is this:

{=MIN(IF(M38:M44>0,M38:M44,M37))}

Any help would be greatly appreciated

By: Wylie

]]>

Thank you

By: Dustyn

]]>I am trying to achieve the following using a macro. When I select few cells in a range and then I click on a button then the selected cells should populate some value as “Y” as shown below.

Block 1

Col1 Col2 Col3 Col4

Row1

Row2

Row3

Block 2

Col1 Col2 Col3 Col4

Row1

Row2

Row3

When I select any range in the block 1 then the block 2 should populate a value Y for the Block1 selection. As block1 range selection is dynamic.

Request for your guidance

By: Rohit

]]>

Is there any way to do this?

By: Jen

]]>

So If I enter a date in column A(12/1/2014) and in B (12/20/2014), I want C to show me the difference in days (19). If I enter a date in A(12/1/2014) and number of days in C(19), I want B to auto populate as the if it they were added together(12/20/2014).

It would also be nice if B wasn’t automatically entered it just autopopulate to “TODAY” so the number of days “C” would automatically add “1” each day.

By: Jessica

]]>I have a set of data that i want to be able to calculate averages from subsets of the data; for example… Have temperatures for every minute of the day but want to calculate the average temperature between 10am and noon; then also between 1 and 2pm. Is there a way to keep the temperature and time dataset as a reference and then use times as the reference to then calculate an average?

Thanks for your help,

Anna

By: Anna

]]>I am looking for a code to loop through cells and add them to the selection, in order to merge them all at end of loop.

Regards.

By: Mo

]]>and i thought hlookups would be as easy …but they are not (for me anyway)

I have an array and i need to look over some columns and see if a string

(Which comes from a drop-down list on sheet2) is there and return another value from the array

any ideas ?

i cant work out how to attach a sample spreadsheet …sorry

By: Eddie

]]>By: Paul

]]>Hello,

I have a spreadsheet with 3 columns

Column A has barcode Numbers

Column B has the product name

Column C has the product QTY amount

I like to scan a barcode in column A starting at the 2^{nd} row and if the barcode is listed in column A it will increase the QTY number by one in the correct barcode row in Column C.

I also like if the barcode is already listed in Column A is will not list it. (It will do nothing). I will just scan the next barcode.

The formula I have in Column C is “=COUNTIF(A2:A10,A2)”

I will send you my spreadsheet to show you what I have so far.

By: Derrell Dulin

]]>