id#

I am looking for a formula to help me in my spreadsheet. I want it to look for the month of January and an ID# with the amounts in that row to copy it into the next 11 months. So January would be column B and ID# in Column E, while the data i want to copy are in J, K, and L. It should display...

Hi, I'd really appreciate if you can please help me construct the formula needed to bring multiple results from many rows. (I know that a regular VLOOKUP will only bring the first result but here it's possible that there will be up to 6 required results). I received a file "Current", which lists...

I have some data in Excel. This is already sorted into the correct order. I require to set the value in a new column to true if it is either a solo record (ie only one distinct ID#) or if there are several entries for that same ID# then set the last one listed to True and the other ones above...

I have two sheets. both sheets have a specific Family ID# per row. On the first sheet I would like to show the data from specific columns on the second sheet for the matching Family ID# Row.

Hi there. Looking for advice on which formulas to use to determine the number days between two spreadsheets. I have one spreadsheet which contains point issuance information. On this spreadsheet the following fields are present: ------------------------------- - ID# - Transaction Date -...

Hello, I was given a file to clean up. It has over 15,000 address entries in a row format: <tbody> ID Agency 201 Name Address 1 City,State, Zip Phone # </tbody> There is an id number assigned in the cell in column A at the Agency name. All the address fields start in column...

Hi guys, I need some help creating a find & replace macro, with the find/replace values contained in a completely separate Excel file. Here's the scenario: I'll have a list file: D:\\Excel Files\List.xlsx This file contains only 2 columns, one titled "Name" & the other titled "ID#". Under...

I have one spreadsheet that has Last Name, First Name in one cell. I have another spreadsheet where I have ID#, Last Name, Middle Initial, First Name each in separate cells. I would like to use INDEX and MATCH formulas to bring over ID# to the first spreadsheet. Is this possible? Thanks!

basically I cant get the equivalent of the RIGHT formula to work in VBA... Heres what i am trying to do: I have a textbox on a form that gets populated with the string: "INCIDENT ID#: 18-389" Where the '389' part is increased by 1 each time the form is opened (when opened it checks for the...

Hi all, Currently having an issue doing a vlookup. For what seems to be something very simple, it is not working as it should and I am not sure if you could help me out. I think it could be due to the fact that the files are different, but once again I am not sure. I am looking to get updated...

I have a roster in Excel (2013) that we use to track student status. In a separate worksheet tab, I have a list of students who we send information to. What I would like to know is how can I use a lookup method (vlookup or other means) that will compare the ID# which we have column E, to a...

Dear all excel experts, I have tried to use INDEX and MATCH yet still can't figure this out: Table 1: <colgroup><col><col></colgroup><tbody> Remark Currency Amt Vchr# 100799, Pymt ID# flliqtaxcc0558902062, Supplier: Dept. of Bus. & Pro. Regulation, Cash Acct - A/P Acct 67,999.13 Vchr#...

I have two columns, one is an ID# for a particular institution submitting data and the other indicates the type of institution level. An institution might have submitted more than once and each submission is a new row. I want to know if each time the institution submitted, the data is missing...