hill

Hi All I've been trying to rack my brain for ages just cant work out how to use a formula to force user to end entry with 7 numbers. (Case of the letters is not important) For example these should be ok: Hill J 1234567 Joe R 1345647 Smith 9864567 These should fail: Hill J Smith Joe R 123...

Hello I am looking for some guidance on the below Macro. I have a table (Table1) on a tab named "Arrears Report". The table has a list of property names on it and their arrears. The table has 15 columns. I am looking to generate a tab Per Property Name with the corresponding data for the...

I have sheet1, where there is a table in below format. <tbody> A B C D E F G H Prop ID: Leads ID: Caller Category: Duration: Type: Name Date Link ONI10P07 7631565 Prospect New 5 Phone Jack Hill 09/04/2018 www.google.com ONI10P07 7631578 Prospect Followup 20 Phone Jack Hill 09/04/2018...

Input:C1 Mary went down the and hurt her head D1 hill Desired Output: Mary went down the hill and hurt her head Below is the best what I can describe the logic as: (If C1 contains "keyword") (Separator " ") concatenate [D1] as "[C1...Keyword][Separator][D1] [Rest of C1]" Below is the...

I have a Spreadsheet which I have linked to other sheets effectively, (thanks to this board). I now want to go one step further and be able to write in a name in a column and within the same column, return a number (in this case a duty no.) I have tried Vlookup, if and match and so far, I have...

I'm attempting to do a lookup from data organised like: <tbody> Name 7755 7756 7757 Hill 100.00 25.00 98.00 Smith 10.26 896.57 3215.14 Black 18.76 12.00 47.86 Hill 56.98 25.47 33.59 Brown 1254.26 8569.24 4529.10 Hill 5869.25 5689.24 1.56 </tbody> In my lookup sheet I have the...

Hello, I am trying to lookup a data from table 1 to table 2 however, the vlookup is not matching locations and picking up the first role it finds: See below: Column A Column B Column C Column D Column E Column F Column G Column H <colgroup><col><col><col><col><col...