cup

Hello everyone, WIll try to explain this as best as I can Starting at A1 Row 1 is conditional row for the code <tbody> John 22 Apple John Apple Mark Cup John Cup Mark Apple Steve Pen Mark etc etc etc etc etc etc </tbody> What I wish for is in other sheet rows from column A...

<tbody> A B C D E F DATE FREE TEXT ENTRY FORMULALEFT FORMULAMID FORMULARIGHT FORMULAMID 09/01/18 234 park st northwest pl1235 =LEFT(B3,10) =MID(B3,5,11) =RIGHT(B3,10) =MID(B3,6,8) 09/01/18 pl1235 park st nw 234 =LEFT(B4,10) =MID(B4,5,11) =RIGHT(B4,10) =MID(B4,6,8)...

Hi Gurus, I am trying to achieve the following: I have a table with wet and dry ingredients. Based on their replies it will determine if the conversion is either wet or dry. (ex: 1 cup of milk and 1 cup of flour, or 1 tsp vanilla extract and 1 tsp salt, will not weigh or be measured the...

Hi all, I've been racking my brain for a few weeks with a spreadsheet I am working on for the world cup. I am trying to create a lookup for a sheet which tracks statistics of players entered into a template sheet which I have created to record match results during the world cup. There will be...

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...

Hello, Need help! I tried searching google and the forums, but for the life of me I can't seem to find what I'm trying to look for. I have a list of data in sheet1 and I'm trying to copy/paste each line into sheet2 on every 3rd row and then fill down the blanks. The list of data changes daily...