rob

Hi, Is there a way of hiding my formula's within the program I put together?:confused::confused: Warmest Regards, Rob

Hi, I'm just trying to create a formula where for a given column it will only return a value say "X", if a specific "word" (e.g Rob) is repeated more then 3 times immediately in a row below or above it, otherwise return "A". For example: Rob -X Rob -X Rob -X Rob -X Janet -A...

Hey everyone I want to create a workbook that keeps track of certifications of employees across different shifts. My goal is to have a master sheet that i update and have excel create tables in new tabs for each shift. I need the table to update when i change something in the master sheet...

Hi guys, Id like to be able to highlight or otherwise see any cells with a formula with link to a row higher than lets say 240 Any thoughts would be most welcome! Thanks! Rob

Hello, I am working on a spreadsheet that has the following setup. What would be the best way to find out which projects each person is on? I was thinking of doing a vlookup, but I would like to know if there is a better alternative. <tbody> Project Resource 1 Resource 2 Resource 3...

Hello - i am trying to write an equation that counts the number of unique values with a criteria associated with it. Below is an example data set, what I want to count is a number of unique animals (column A) but based on a criteria (column B). Using the below I would want an equation that...

Hello, I need a macro to remove duplicates by row and also remove the blanks. Its a huge data by rows and columns below example - duplicates "Rob & "goal" to be removed, but should retain unique and remove the blanks <tbody> gulf Rob stat Rob aim hero fun goal view review page goal...

Hi I am using excel 2013. I have individual sheets for each team member that use 'networkdays' to calculate holiday used between a start and end date. I would like to put a letter 'R', 'A' or 'D' in columns in a summary sheet depending who has booked holiday. I can't attach the workbook I am...

Hi Guys, As the title suggests I would like to perform a sum on a group of numbers, which will be in one cell, with text associated with them (the text lines will always remain the same, example data below) <tbody> Data Answer Rob 5 Jack 10 Stan 5 Denise 17 15 </tbody> The above shows...