address formula

Hello all, Hoping somebody may be able to help with this as I've tried many different solution with no luck! My issue is that I get addresses exported into a spreadsheet with all the address information put into one column. These addresses have no commas, and follow different structures to...

Hi, I have this dynamic range which depends on dynamic data and below condition: If the value in cell AC10 is not equal to any of the values in Range: AK3:AK9 then change the formula should be...

Hi, I need to split some addresses with formulas and am not sure the right way of going about doing it. I currently have two workbooks. One called Raw Data which has a series of columns and the other called master which looks up the raw tab. On the raw tab there are 6 columns that are like...

Hello, Struggling with the following formula. I'm assuming my issue is with the variables in the Row, Column, and Match areas since the formula works just find when I use a specific range on Excel itself. However, the row number needs to change so I'm stuck needing to use a variable. How...