#range

  1. Adeneen

    Count Numbers in Contiguous Number Range

    Hi Everyone, New to the forum and really appreciate anyone who can assist. Below is a simple version of a much more complex data set that I am working on. I am trying to get excel to identify numbers within a contiguous number range in a single cell and place an "X" in the corresponding...
  2. G

    Updating Selection Lists with Pivot

    hi all, I have an excel workbook in which I want to automatically update selection lists based on the user who is logging in and which selection is made from a few dropdown boxes. The user does the following steps: 1. Login (the username is saved to named range called cCurrent_User in the...
  3. R

    Copying Data of A Named Range into Another Worksheet

    Hi everyone. I have a simple query. Is there a simple way of copying the data of a named range into another worksheet? Thanks in advance.
  4. P

    Vlookup combined with another excel function to return a value depending on a pre-defined range

    Hi, I wonder if anybody could help with this one: You have a table with invoice numbers and amounts by vendor. The job is to add a "User" column into this table using vlookup and/or other excel functions showing User1/User2/User3 linked to each vendor name, when you have a reference table on a...

Some videos you may like

This Week's Hot Topics

Top