smith

Can I do this. I want to select only Smith. I want patients who do not have a billing code of Z00.00 or Z00.129. the data is across 6 sheets. I want to export only Smith. Name Pat# Bill code Jones 123 F34 Jones 123 H01 Jones 123 Z00.00 Jones 123 090 Name Pat#...

Good Day, I am hoping there is someone that can help with a formula. The problem is the data is not captured constantly. So i have a name that gets captured in 3 different ways I need to find the value of this person for a specific month. Please if there is formula that I can use would be...

Hi All I've been trying to rack my brain for ages just cant work out how to use a formula to force user to end entry with 7 numbers. (Case of the letters is not important) For example these should be ok: Hill J 1234567 Joe R 1345647 Smith 9864567 These should fail: Hill J Smith Joe R 123...

Hello all, I am looking to see if someone will help me create a macro that would flatten a data table (or move the data from rows into columns) by Name and Activity in excel. Basically I need to go from this (but there will be many different activities per name): Name - Activity - Start...

Any one have a small bit of code that would take a name and swap it around Select the cell, button press reads the cell value and John Smith to become SMITH John. Not worried if it doesn't handle more than two bits, have a number to work through, the odd one is not too important in the grand...

I have a worksheet named "MINE" and need that when I open it my username appears in cell A1. I need that my username will be full name, example Tony Smith. Thanks in advance

<tbody> A B C ID1 ID2 Name 001 A010 John Smith </tbody> Hi All, I need some help here. basically, some of my employees have 2 IDs, If I vlook A, return is N/A, then I should be able to vlook B to get the name "john Smith". how can i put that logic into one formula? Thanks,

<tbody> A B C D E F 1 Team Name Rating Man of Match 2 United Smith 10 Yes 3 City Brown 9 Yes 4 United Robinson 10 Yes 5 United Smith 10 Yes 6 City Brown 8 No 7 United Smith 9 yes </tbody> Excel folk Once again I turn to...

Hi Everyone! I am curious to see if anyone can help me with this, I have the following macro to export as a PDF in excel: Sub SoA() ' ' SoA Macro ' ' Application.ScreenUpdating = False Sheets("Super SoA").Select ChDir "M:\New Client\Created PDF" ActiveSheet.ExportAsFixedFormat...

I have a query which displays records linked to companies based on the ID: <tbody> ID Name Date Current ABC123 John Smith 01/01/19 Yes ABC123 James Jackson 22/12/18 No LMN321 Sam Franklin 12/10/18 No LMN321 Danny Hudson 25/12/18 No </tbody> Is it possible to make the records show 1...

hi, how do this: A1=Jhon Smith B1=Orange C1=500 A2=Peter Award B2=Bannana C2=200 A3=Jhon Smith B3=Lemon C3=210 if i want do a Vblookup formula for find: Jhon Smith and Lemon ? Thanks

Hi Guys, Having a little trouble with a look up I have tried Vlookup with no luck and I have Tried Index Match... But I think I'm missing something important - or at least not getting it exactly right. <colgroup><col><col><col><col><col span="3"></colgroup><tbody> A B C D E F 1 First Name...

Spreadsheet 1 is the list of names, dates, meter readings I have started with and I need to split the names on to new worksheets as per spreadsheet 2 Spreadsheet 1 (master worksheet) <colgroup><col width="246" style="width: 185pt; mso-width-source: userset; mso-width-alt: 8587;"> <col...

I have a sheet of roughly 2,000 investors. I am trying to keep track of each of their investments. Some of them invest indivisually, some invest through a specific account. For example, John Smith has invested through three different accounts that appear as follows: Column A Column B...

Hi, I'm trying to use INDEX, MATCH and SMALL to return multiple results and having some difficulty. On Sheet1, I have the following data: <tbody> Study Investigator Study123 Smith, John Study123 Smith, John Study123 Smith, John Study456 Smith, John Study456...

I don’t know what to call this, but someone has had to have done this before. Sorry if I’m searching for the wrong words on here, but I can’t find the answer. Thanks for your help in advance. I’m getting a data dump of random contact information, most of it I can sort pretty easy except the...

So guys, I have a problem...tried using several org chart style fixes...but essentially I have multiple links to the same manager (using the org chart terminology)... So essentially I have the following data Owner, Account, Beneficiaries Mr Smith has account 1 (his own account) Mr Smith is a...

I have over 6000 rows of data. I have sorted it so each person has 2 lines of data that need to be added together. Each cust has 2 rows of data that need to be combined, but I need it to return the information in each column Row 1 (Col A - D) = Headers A Cust No B Name C Type D...

I have a list of names, departments and phone numbers in row A. Entries are separated with a cell with 0. Here’s an example of the layout of the data. <tbody> John Smith ABC 999-999-9999 0 Jane Smith ABC 888-888-8888 777-777-7777 0 Alex Smith ABC </tbody> Some entries have more...

I have a spreadsheet with employee pictures that uses a VLOOKUP so when you select John Smith in the dropdown, a picture of John Smith appears in the dashboard along with important employee stats. What is happening is that every day or two, I notice the picture is on top of another picture of...