sourcing

How can I do a SUMIFS (or similar) where columns/rows are transposed and columns have the same label (like B&D below). In my data sheet data is organised like: <tbody> 3100 3587 3100 3800 Talent 200 320 124 256 Sourcing 90 77 85 784 Media 45 69 30 941 Talent 426 25 24 4256 Sourcing...

How can I do a SUMIFS (or similar) where columns/rows are transposed. In my data sheet data is organised like: <tbody> 3100 3587 2568 3800 Talent 200 320 124 256 Sourcing 90 77 85 784 Media 45 69 30 941 Talent 426 25 24 4256 Sourcing 497 74 85 287 Media 569 36 26 365 </tbody>...

Hello, I've been trying to figure something out and currently I am required to use vb sourcing for a solution to my issue. My issue is trying to freeze a formula which is =IF(A3="","",IF(B3="",NOW(),B3)) after someone places the input into A3. I need it to freeze so if that user deletes what...

In my company's reports we often have a source column that lists the formulas pertaining to the cell next to it. example Row item value source <tbody> 9 Total Market Value of Assets xxxx (R7 + R8) * R2 10 Difference xxxx R9 - R6...

just thought I would try my luck: are there any others out there who rely on UNSPSC to categorise vendors/suppliers? I am especially interested in Aussie members or others who have extensive dealings with Aussie vendors. I am trying to categorise my companies suppliers at the moment and its an...