water

I have a list of dates & times in column A, in colum B I have a list of events that happened at that time I want to create a list of dates an times of every time a specific event happened eg A 18/2/19 12:53 Water 25/1/19 18:22 Electric 27/1/19 21:13 Water 27/1/19 23:30 Dust 27/1/19...

I have a list of ingredients in cell A1. Each ingredient is separated by a comma (,). How can I move each ingredient to its own row? EXAMPLE: ORIGINAL CELL A1 = water, sodium lauroyl methyl isethionate, glycerin WANTED CELL A1 = water CELL A2 = sodium lauroyl methyl isethionate CELL A3 =...

Hi All I think this is a question to test the chaps who specialise in difficult formula I am working on something that requires me to adjust tide times from UTC to a format that accommodates the seasonal changes in the UK for British Summer Time. Below is an explanation from the UK Government...

Hi Can I do multiple column Vlookup. I searched the internet but most of examples are using Match-Index. I want to learn multiple Vlookup first then I will go to match-index. I am thinking of array function but do not know how to start I have the table below. I want to do the following Enter...

Hi guys I have the following macro: Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range If Target.Cells.CountLarge > 1 Then Exit Sub Set rng = Intersect(Target, Union(Range("E4"), Range("A10:A19"))) If rng Is Nothing Then Exit Sub Select Case rng.Address(0, 0) Case...

H guys, great forum been checking in a while now, so thank you in advance. I am by no means an expert but can do a few intermediate things. I have a question around grouped transpose - or thats what i have called it. I have a list of customers that have been collected without any thought of...

see attached file, im trying to find out if any of the ingredients from column D exists in column A and display whatever ingredient is found in column B, is this possible? need to go through lots of ingredients and find anything that needs special instructions see below example <tbody>...

Worksheet1 <tbody> LastName FirstName Code ID E Group Address H Group2 Address2 K Group3 Address3 Smith John 01, 03 123456 Place1 123 Main St. Jones Fred 06 852547 Place1 123 Main St. Place2 345 Water St. Place3 567 High St. White Barb 03, 123, 04 258787 Place1 123 Main St...

Hi all, i would like to "SUM" the below numbers using a VBA code which should base on description in col. "AK". In F.1. are the original data and in Sch.2. is the expected result. Therefore that the rows are not stably and are change due to accounts which have movement for each month...

Hi - I am looking for an example of an example of a macro that would do the following: It would an IF statement... * Check to see if a cell contains a certain word (say "water"). * The word can be anywhere within the cell (say cell A2) * If the cell contains the word THEN set cell B2 to a value...

Here i paste one excel report. In this, In need to make a report form a Master data with search keys.. please find the attached file and help me please... thanks in advance.. <tbody> Master Data Item No. Name Code Price Cat. 245 Apple Red UK 1.50 10 4157 Orange Naval USA USA 1.30 11...

Hi There, Here is the problem: Say I have 5 inventory of products (liquids): Jan Feb Mar Milk 5 10 1 Water 7 8 40 Orange Juice 10 32 3 Now say I have the following containers: Container 1 - capacity 1 Container 2 -...

I am trying to create a chart, I can see it in my mind, but I'm sure I don't know all the correct jargon to describe it. The x-axis will be analytes (F, Cl, Br, etc) and the y-axis will be a concentration value. I can do this with a line chart. The problem I'm having is that each series will...

Hello! I need an Excel macro that finds words or phrases in uppercase, then surrounds them with the html tags for bold. The uppercase words can have as few as 2 letters like "NO", and there can be more than 1 word in uppercase, in which case I want the tags to surround all uppercase words that...

Hi everyone, I'm hoping someone can help with this one - this is my first post so please have patience!I have a spreadsheet representing boreholes and where the intersection is for the weathering horizon. I'd like to be able to reference a water level table (on a different sheet) and return...

HI all I'm looking for a formulae to calculate the total costs in "tab numbers" it needs to sum the costs of all sites (for example water) in a month: the volume in each site (tab volumes_table) multiplied by the cost each site (tab variable cost_table) example of one site only (AT1...