extracts

I'm looking for a best practice as to how to handle changing measures when your source data changes. We're in a (continual) fact-finding mode with our data. The extracts from our various ERP systems are complex, such that the names and logic of columns can change as we slice 'n' dice and come...

Kindly help me convert the following formula: =IFERROR(INDEX($B$3:$B$15, MATCH(0,COUNTIF($D$2:D2, $B$3:$B$15), 0)),"") So that it only extracts unique value if a given range contains a specified value. Thank you.

Hi, I currently have this long string that I need the date extracted from. The date pieces for below is as follow: YEAR = 2017 MONTH = Dec (this is because January is 0 so in this sample Month=11 is Dec) Day_OF_MONTH=28 Would it be possible to have a formula that extracts the date and...

Hi All, I have database where one Colum is for Stores Like Stores Home Depot Home Depot First Home Depot Second Ralphs Food 4 Less . . . . . . . By Macro Im trying to extract data for store “Home Depot” only. In Criteria range I have: Stores Home Depot Sub Filter_Stores()...

Hello, I would like to use de application.Index function to extract a value from an array. The value es de last one in column 6. I Don't know how to write it. I have this code, which extracts the entire column. y = Application.Index(resultArray, , 6) Thanks :)