houses

Hi, I have been racking my brain with this for days now trying different things but keep ending up with circular references when I think I am close - I do not think there is anyway to do this without VBA if it is even possible with VBA as I haven't found anything close in searching. In the...

<tbody> A B C D E F 1 Name Date Time Incident Type Written description Action taken 2 Emma 05/08/19 14:00 Environmental I was walking across site and saw water gushing out of a pipe near the sheds at the back of the houses. Quite a large puddle had already deveoped and it...

Let's say I have a spreadsheet that has all towns in the world. All towns have houses in it. All houses have items inside. All those items have smaller items inside. And so on until row level 6. I want to make a macro that based on my filter search opens all of its children. For example if I...

I have data on rental prices for houses in the city of Mumbai. It contains approximately 12000 addresses, their coordinates, area, rental price and number of rooms. In a separate file, I have 1000 addresses with a lot more variables (but they also have the coordinates, area, rental price and...

I am working on a model of charging load of electric vehicle. I am attaching a link to an excel workbook for your better understanding. Column B contains random time values Column G to P represents houses and each house can have 1 car. So the each time values needs to be distributed in one...

Hi all I'm creating a Spreadsheet for my schools Sports Day. It's quite a simple document, but am trying to automate some of the functions a little, to help my PE department, make the day a little easier. Problem is I'm stuck on one section, and was hoping for some advice and suggestions...

All training from 0000000 to 3333333 without repetitions. Ex = 0000000 0000001 Can not have 0000100 = because it is repeating 0000001 It has to stay the perfect matrix of 7 houses

need formula Philadelphia Contributionship for the Insurance of Houses from Loss by Fire W4Z6QA69 Comprehensive Insurance CI25874567 4000 1 Year were find and put dildimeter like ^ before ^W4Z6QA69 Philadelphia Contributionship for the Insurance of Houses from Loss by Fire ^W4Z6QA69...

hi all... how to make lookup formula with 2 index (id_1 & id_2) like this : <colgroup><col><col><col></colgroup><tbody> id_1 tipe id_2 4010106010 Buliding A 1 4010202007 Buliding B 1 4010205001 Permanent 49 4010202004 Resident 1 4010205001 Houses 46 4010205001 Houses 38...

Hi good people!, I do not know if this is do-able with formulas, I do hope so.. I have in cell A1 and A2 a word "House", and in A3 a different word, in A4 again "House", and in A5 a different word. These text's are derived via formula. So, I have 3 "House" words and 2 indifferent ones. In...

Hello All, Column A houses alphanumeric values. Column C houses 0s or 1s. Column E houses text. What I would like in Column H is a list of unique values extracted from Column A where values in Column C is 1. In Column I, I need to extract a unique list of values from A where cells in Column C...