Search results

Hi all, I am having some trouble with getting the required results from a multiple VLOOKUP ( INDEX, SMALL ) when I input a > sign rather than an = sign ..... i.e. my formula is INDEX(page!$B$1:$U$2671,SMALL(IF(page!$B$1:$B$2671=3,ROW(page!$B$1:$B$2671)),ROW(page!1:1))*1,2) page is the sheet...

Hey Paul ,,,, Sorry for the late reply ,,,, been a busy day today ,,,, this works a treat, I wasn't too far away with a sumproduct and countif ,,,,, much appreciated, thanks again :)

Thanks for the reply Paul F ... I just posted an update to my request ,, I have tried COUNTIFS ... even a sumproduct with countif ,,,, it's the unique piece that is throwing me.

Hi Hui, apologies ,,, my mistake ,, I should have said that I am looking to return how many unique Names are in Col C ,,,,, so H2 result should be 2, H3 should be 2, H4 should be 1 and H5 should be 0

Little conundrum .... maybe i ahve been staring at this for too long ,,,, sample file attached .... I need the results in cells H2:H5 to count the number of Names that appear in Col C that match the date in Col B ( example date in H1 ) and the Code type in Col D ,,,, results should be as per...

Try the attached ,,,, remember with an array formula you have to press Ctl + Shift + Enter at the same time.

Can you post a sample file?

Sample file attached ,,,,, should be self explanatory, main table of data shows the info per product item, smaller table to the right is a summary of the total dimensions for each storage type ( pallet, shlef, floor ) as well as number of each storage type. From this data I need to work out how...

I have a poser for the guru's and ninja's ..... I am looking to create a model in Excel that will allow me to work out the capacity ( warehouse space ) need for a set of products. I have the dimensions of the products themselves and can work out if they will fit on a shelf or a pallet ( in a...

See if this helps .... http://www.mrexcel.com/forum/excel-questions/290247-percentrank-multiple-conditions.html

Hey, Never tried this, but you could try this ,,,,, on the Data tab, click Connections, you should be able to link two workbooks that way, but never tried it myself.

What?? Are you asking if there is a macro code that will change each of the 100 workbooks??

Hi Hui, I have emailed Chandoo, but I know he is a busy person ,,,, I purchased the Excel Wedding Planner file back in 2011 and my daughter announced a month or so ago that she is planning to get married next year, so I thought about using the wedding planner file, but cannot find it ( I think...

Thanks guys, appreciate the replies, I really need the full version, this looks like a read only version.

Hi, sorry for the late reply, not had much time to look over this ,,, but a good reference point is this ... https://www.lokad.com/calculate-safety-stocks-with-sales-forecasting Let me know how you get on if that helps or not.

Can you post an example file?

Try this in Col C ,,, =IF(A2="TBD","",MATCH(B2,LARGE(IF($A$2:$A$15=A2,$B$2:$B$15),ROW(INDIRECT("1:"&COUNTIF($A$2:$A$15,A2)))),0)) I put TBD into some of the cells in Col A as I don't know what else you would have other than "wait list" in Col A ..... the formula is an array formula, so must be...

Hi All, I have written to Chandoo separately on this, but also wanted to check within the Forum Guru's ..... I purchased a copy of the excellent Excel Wedding Planner from Chandoo and Kevin back in 2011 ,,,, long story short, I cannot find it ( I think it's stored on an old corrupt laptop ) ...

Yeah, wasn't even for me, was for a senior manager, let's see how often it gets used and if they decide to make changes ..... but they have what they asked for, I was on the right track, just couldn't figure out the last piece of the puzzle ,,, which is why I love this site, so many helpful...

That works ,,,,, I was starting to look at Helper columns as well, you beat me to it, Thanks, appreciate the help :)

Hi, They actually shipped on 04/08/2014, same BR DO No., so the formula should not count them as the BR DO No. appears as shipped on 04/08/2014, they show up on the report I receive as it is a data dump from a system that show all data either shipped or not, it's the BR DO No. that is unique in...

Works to a certain extent, although it returns a value of 3,991 on 05/08/14, when in fact that qty actually shipped on 04/08/14, snapshot attached to show what I mean, your formula results are on the right ,,,, the left hand side is what it should look like ...

File posted here .... http://www.fileswap.com/dl/9HE86QTkAf/

Hi, B7 contains a part number ,,,, 123456abc and M6 contains the heading Shipped, the formula currently returns the correct information in that for 123456abc that have shipped and looks at Frequency of BR DO No. returns the value of 4,571 ( the qty of that part number that have shipped and not...

Hi, file would not upload, below is a snapshot of the data, let me know if this helps.