names

Greetings, I import names and addresses into a database for mailing lawn care offers. I get the data from various county administered tax rolls. I can specifically target particular neighborhoods. The data is different in the various counties we serve. The homeowner names are in various...

Hi. In my sheet I have data in a b c & d which can be a yes or no. Column E contains a name or email address. I want to create a 'league table' where if there's a 'no' in a, it's 1 point, b =2 points, c=1 point, d=1 point There are hundreds of rows and the names in E can be the same, I want...

I am working on a workbook for someone. The workbook is to schedule people in a duty roster. As the number of names is large, there is a big possibility of two or more people with the same name. That is why I want to store the ID number in the cell with the name. For clarity on the screen I...

Hi Again Guys... I have a list of 'stats', from a list of names, but... theres always a 'but'... I have 52 rows for names, but sometimes only 45 or so are populated, how do I get the percentage to ignore a blank cell where a name should be ($A:$A)? <tbody> John 1 Mike 1 Debbie 1...

Hi I am after an equation either sumif or countif, whatever is best for the following two scenarios. Scenario One I have created a workbook on excel with several sheets that automatically filters names of people that have attached specific tasks they complete onto a summary sheet. The sheets...

I have a spreadsheet with a column of names and column of dates. The column of names have duplicate names for same dates. I need to count how many names were on a certain date but my pivot table only sums the name column. I there a way to count the individual names that appear for each date...

Hello, I have several excel files with the same structure, and these files' names being country names (Portugal, Spain, Greece, etc.). In a separate file (File Output) I would like to return the Cell F4 from Sheet 1 of all these files into column B. In File Output, I have the names of...

Hi Guys, I am working on a piece of work where i ahve a list of names and dates next to them. What i would liek to do is excel to scan all the dates and any date less than today to return the name to the left of the date however i only want it to build a list of names that have expired and not...

Hi guys Just as a simplified example I have the following data Column A Col B Col C Product May June Item1 5 2 Item 2 8 3 I would like to create new column names "Change" calculated...

Hi, I have data in a table that has a range of numbers in col A and various names in Col B. I'm trying to get a formula to check through a column of numbers find the numbers that are less than 5000 and return the name in the adjoining cell from the same row and create a list of the those names...

I have a workbook with only two columns. Column A contains the server name. Column B contains the software names. There are up to 100 software names associated with each server. I need to see all the software on the servers that have software X loaded. If I filter column B for X all the...

Hello All Problem: The Excel I have has some pictures embeded at start (A1:H10) which can vary in different templates below this there is header, below which is a table (headers for column names start from A12) Since column number can change , I need a way to extract whatever data is there...

I'm having trouble with this code working as a deactivate. As of right now I have it working as a 'Update Name' Command Button which works fine but users are forgetting to 'Hit' the button and the names they are looking for are not showing up in the updated list. So, if I could have the list...

I'm building a chart from 3 series of data. Mac Excel 16.16.12 The issues: Adding data series 1 is all ok and called "Series 1 "Point A"" on the chart. All category names on X-axis are correct. Adding series 2 is ok and called "Series 2 "Point B"" on the chart; however, "Series 1 "Point A""...

I have the following statment within my formula and it work as it is, it bascally returns "Yes" if K2 = "Liverpool". =IF(K2="Liverpool","Yes","No") However I have a list of 12 names in tab "Lookup" A1-A12 and I want to expand the formula above to also check L2 and if it matches any of the...

Hey all! I have a very long list of employees in which I need to extract their names into a consistent format. I'm using the below formulas with a 99% success rate, however employees with a suffix of "JR" or "II" (etc) are throwing a monkey wrench in the calculation. First...

Hi Everyone, I have list of about 3000 names down column A that are the names for each range, every range needs to be "The row the names in" Columns C:Y" is there a macro or easy way to do this without adding them all manually? thanks Tony

Hi, I have made some tables but having an issue trying to sort them. Some info for you. Worksheet is called INFO Tables have headers in row 1 GRASS NAME CV2:CV16 GRASS ADDRESS CX2:CX16 GRASS PAID CZ2:CZ16 GRASS MILEAGE DB2:DB16 What im looking to do is place a macro on a button which will sort...

I need to add the text "ABC" to the end of some worksheet tabs that already have names. It's a couple hundred sheets in the middle of a large spreadsheet, so I cant use code that selects the entire workbook. Thanks

Hi running 97 at work. Got vba code to count cells based on colour . Now want to be able to count based on contents ( text - names) and their colour. How do.i do it in both 97 and 2018?