Search results

Hi all not been on here for a while and hoping someone can help as I'm struggling to get to grips with calculated fields :( I have a pivot that gives me a count of a reason name. The reason names are text values in the table (DOA, Wrong Product etc) I'm trying to multiply a count of the reason...

Thank you for both the welcome and the formula! I realise I was heading down the wrong path and your formula above has set me on a better course, having spent most of this morning on the issue I have finally cracked it! Steve

Hi all I'm trying to write a workbook to do a comparison between sets of data, where the user can simply dump three sheets of base data in and an output sheet will highlight errors. background: some guys in our customer service dept have to carry out SKU movements on two systems and I need to...