matthew

Hi I'd like to create a sumifs formula which sums up negative values only. I've created a simple example below, where I've written a sumif which sums up the values for the name "Matthew" in column B (you can copy and paste the data below into a new workbook - it starts in cell A1). There...

Hi all, I have an ever growing list of orders with the order numberbeing in column D. Sometimes an order will have 1 line, sometimes it may have10! What I need on a second sheet is a dynamic formula whichwill pick up all the order numbers and just display them once on this secondarysheet...

Any recommendations on vba for the following In Sheet 1 Search for user “Matthew” Select and copy the row Matthew and paste in sheet 2 Search for user “green” Select and copy the row green and paste in sheet 2 underneath Matthew row

I have failed using previous similar messages..... I need a code with Set Cell - Q17 To Value - Q2 By changing - B2 Appreciate any help you can give on this Regards Matthew

I'm looking for a formula to place in column C that will look for the value of A1 in column A, and then return the first non-null value in column B. Google seems to indicate that an INDEX/MATCH formula would be the way to go, but I can't seem to get it right as I admittedly haven't worked with...