steve

  1. S

    Conditional formatting multiple colors based on multiple data

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

    How to ad the text in column B to column A

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

    Counting rows per individual

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

    multiple vlookup options... again!

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

    Return two values based on another

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

    Ribbons: Make Unique to Data Sheet

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

    Count Unique Values across two (2) columns - similar data in each column

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

    Lookup value in A, and return first non-null value in B

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

    Best Practice or Suggestions on Creating a Register for Transactions in a INPUT and OUTPUT of Block / Credit Data

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

    Org Hierarchy - Index & Match?

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

    Compare multiple cells and match

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

    adding strings together

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

    Massive 'IF' Function Problem!! VCE SAC!

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

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top