Recent content by Busymanjohn

Hi, i appreciate this, but this isn't what I am looking for, the hidden rows still need to contain the vlookup formula

ok

I am trying to replace the vlookup formula with their values, .... the vlookup returns the value correctly, now I want to replace the formula with just the value, so no formula at all ( except those in the hidden rows ).

Simple file added, I have hidden rows 4-6, i want to keep the vlookup formula in there, but want to replace all other unhidden cells with the values and not the formulas, e.g. Cell C2 would shows a value of $125 and not the vlookup formula. Thanks

Hi all, I am trying to replace a vlookup formula with values but ignore hidden rows, so leave the formula in the hidden rows, e.g. a vlookup formula in cols a -d and rows 1 -10, i have hidden rows 4 - 6 as i want the formula to remain, but wnat the formulas in rows 1-3 and 5-10 replaced with...

Hi Narayan, sorry it's been a few days since I got back to this, the formula works just fine, thank you for that .. a quick question though, if the same part number_location appears more than once in the report ( which does happen ), how can we ensure that the formula returns the correct date...

Hi Narayan, that seems to work fine ,, one question though, in instances where there is no stock moving out ,,, so has no date, the formula returns 00/01/1900 default ,,, can these be returned as blanks instead?

Hi Naresh, file shared ,,,, let me try and explain a little more ,,, the report is pulled from a system and shows the part and location of stock in and out ,,,, a positive number in the quantity field signifies stock in, a negative number signifies stock moving out, I tend to split the report...

Hi Naresh, this works when the parts are one row apart, but if the parts have rows in between then it doesn't quite work.

Hi, looking for some help on the following ,,,, I have 2 reports, which shows me data on when stock arrives and when it moves out ( dates ) and I currently use VLOOKUP to look at the part and location ( concatenated ) to show me when stock moves out and subsequently calculate how many days that...

Hi p45cal,,, this worked for what I need ,, no need to worry about dates at this stage, I use the dates to calculate how many days product has been in the area from current date, I can do that separately. Thanks again, much appreciated.

Hi guys, I have a query with some data from a colleague and I can't seem to find a solution. There is a sample file attached. Basically, there is a set of data that shows product being transferred into an area and a few days or so later that material being transferred back out ( positive qty...

Thanks guys, both solutions worked a treat ..... :)