susan

This one is giving me a headache. I've been learning a lot about excel lately through googling and such but I can't figure this one out myself. I feel like what I want is simple. I want conditional formatting, 3-color scale, with the midpoint based on the average value in the range. The...

Hi guys, Thank you in advance to those who can help me. I know there's same issue with mine but I can't find the exactly the same because what i found almost on the internet is just only two columns, but in my case I have four columns. I also found code like below, but like I've said this is...

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

I have tracking data that contains many dates for the same person. How can records be cleaned up so that it shows only the latest date for each person. Here is an example of the data: <tbody> Date Personnel Sold 2017-11-11 Bill 87 2017-11-11 Susan 73 2017-11-11 Susan -5 2017-11-09...

Hello Guys! I would like to find a way to look values from one list onto another list, the problem is that those lists will not have the same format all the time and that´s when I would need to look for at least a partial match, let´s put it this way <tbody> List 1 ID Number List 2 ID Number...