steve

Hi everyone, I have a large table.like below <colgroup><col><col><col></colgroup><tbody> 1 2 A1 john steve A2 mary john A2 steve james </tbody> and I have a list like this https://pasteboard.co/HttAw2F.png Now I want every cell in my first table to be colored based on the second...

I have last name in column A and first name in columnB. I need it to combine together in columnA ColumnA. ColumnB Steve. Smith Will look like Steve, Smith In columnA I need to do it using a vba loop

I have a slight problem: Max 2 apples Max 2 Oranges Max 3 Beans Susan 4 Bananas Steve 1 Orange Steve 2 Peas Steve 9 Steaks Steve 3 Bread Rosy 1 egg Rosy 2 Lettuce I want to count number of items per person, ie Max 3 items Susan 1 items Steve 4 items Rosy 2 items How would I go about...

hi all.. i know this has been done to death.. and even by me... however hoping for a solution... I have this table; <colgroup><col width="87" span="3" style="width: 65pt;"></colgroup><tbody> Client Staff Member a max b robert c charles d charles e charles f robert g robert...

Hello, I'm trying to be able to return data from two columns based on a value on the third. The list below shows a DM name, the employee ID number and their score. What I want to produce is a list where for each DM, I return the employee name and score based on the highest score. So in...

Hello, I've been working with a series of Macros for a little while now. I've been setting up little buttons on a page so they are accessible to a user. It occurred to me how much easier it would be to just create a macro and add it to a ribbon. And it's pretty amazing to have. There is one...

Hello, I am trying to find a way to count unique values across multiple columns, but not a combination of values across both columns, but rather unique values *across* both rows. For example: Column A Column B Mark Mary Mark Steve Mary Linda Mary...

I'm looking for a formula to place in column C that will look for the value of A1 in column A, and then return the first non-null value in column B. Google seems to indicate that an INDEX/MATCH formula would be the way to go, but I can't seem to get it right as I admittedly haven't worked with...

Hi guys, it's been a little while. But we have a new challenge. Here's the breakdown: I am compiling a list or more specifically a register of transactions. I have a log of data that is INPUT, and I have a separate log that is OUTPUT. I have both these logs, and want to reconcile them, as a...

Is it possible to use Index/Match to create an Org Hierarchy? For simplicity sake I've put in a few columns. So since the manager is Steve in B2, C2 would populate with Steve's manager (Marcia). A result of that D4 would populate with Marcia's manager (Andrew). A1: Employee Name (John) B2...

Hello, I need a help in comparing cells. Will try my best to explain: 1. Got an excel data with two columns. Col A is "List One" and col B is "List two" Basically I want a program/formula to look in to data within column A and compare to column B. If col A and B has same data then highlight...

Hi I have 15 strings that I need to add together to obtain a part number. Is there a nice way of doing this rather than string1 & string2 & string3 ... etc Steve

Hey Guys, I'm doing a Case Study for school on Excel, but our teacher didnt teach us this. What we have to do is list how many hours the worker has worked or underworked. For example, for Worker A as Worked 30 hours, but was expected to work 60 hours, he Under Worked 30 hours, so in the...