Pop Up Appear If A Persons Name Appears More Than Once

Jun 20, 2008

I would like to have a list of names in column A1 Smith, A2 Jones, A3 Johnson etc. Everytime someones name appears in E1-E20 I would like the adjacent column next to that persons name to turn red. Example: I type Smith in E14 -> B1 turns red. If it's not too complicated it would be good if excel could recognize the name in any font,capitols etc.

Lastly if I could have a pop up appear if a persons name appears more than once in column E that would be great. Example type Smith in E1 and then when I type smith in E4 pop appears--Name already used once do you want to continue?

View 9 Replies


ADVERTISEMENT

Two Different Persons Locking Cells?

Jul 16, 2013

Is it possible for 2 different persons to lock different cells on the same worksheet?

View 3 Replies View Related

Count Of Persons Name In Range

Mar 11, 2008

I want to count how many times a name is listed in the first 5 rows of 36 columns.

View 9 Replies View Related

How Can I Make A Persons Name Read A Formula

Jul 28, 2009

If I type the name Joe Bloggs How can I make whenever i type that name the computer knows to retreive a number or formula from a cell on another or same sheet.

View 9 Replies View Related

How To Send Email To Different Persons With Different Information / Files

Sep 14, 2013

I am running a small size company, creating several excel works to automate the order/ shipment / invoice work. Try very hard to know how send invoice / AR summary email to different customers.

View 2 Replies View Related

Summing Data Over Multiple Sheets According To Persons Name

Jan 16, 2012

formula that will find "John Doe" through sheets 2-10 and check the Win column for a "w"..if a W exists, Sheet 1 will calculate numericaly how many times it shows progressively, but only for his name and not others.

Sheet 1 B7=John Doe
C7 = total W's though sheets 1-10 for John Doe
Sheet 1
B7 C7
John Doe total W's

[Code]...

This is a alteration to an existing question I asked 2 Days ago, I redesigned a new spread sheet to start over with a new approach to it.

View 2 Replies View Related

Five Digit Numbers That Represent A Persons Code

Dec 1, 2009

In one column (f5:F100) I have five digit numbers that represent a persons code. I have five groups of codes, they are 10000-15000, 16000-19000, 20000-25000, 26000-29000, and 30000-40000. In another column (Column H) I have an "X" saying the are qualified in something.

I am looking for how to write a statement that says answers this question:

How many people are qualified in the codes between 10000-15000.

Ultimately I am going to take this number and divide it by the total number of people in the group to get a percetage of qualified people in the group.

View 9 Replies View Related

Calculate Persons Age Based On Current Date

Jan 22, 2008

how do you calculate someone's age nearest today

View 3 Replies View Related

Macro For Sending Emails To Persons Listed In A Column

Mar 30, 2008

I have attached an excel sheet which i wanted to write macro as an attachment. .

when I run a macro an email has to be sent to each persons listed in column A with Voucher # in the subject line and URL in the body of the message after the URL, the body of the message will remain same for all the emails:

so I have typed the body of the message in 2nd sheet:

View 14 Replies View Related

Excel 2013 :: Calculating Count Of Persons Of Certain Ethnicity Relatively To Place Of Birth

Mar 16, 2014

I am Using Excel 2013 on windows 8 OS,

I have no programming background but I have an Idea about it and I try to write some VBA Macros.

I have 27 Excel files which contain each of them 257368 Row Concerning personal information about persons
the File Format is as Follows:

Place of Birth (POB); Name; Father's Name; Family Name; ID Number; Ethnicity,>>

View 2 Replies View Related

Value Appears Hide The Row It Appears In

Nov 12, 2007

Is there a way to get Excel to look down a column for a particular value and where that value appears hide the row it appears in?

We have a series of reports which all have the same template, however we don't want some customers to be able to see some of the products as these are own-label products for which aren't offered to everyone.

I'd like to add this as a macro to a combo-box so that the user can view a report for their customer and then send a copy to the customer with the knowledge they won't see anything we don't want them to...

View 9 Replies View Related

Name Appears Instead Of The Employee ID

Sep 11, 2007

SEE ATTACHED FILE

All,

I have a spreadsheet that lists each employees hours for the last 4 pay periods...each is in it's own row I am trying to find out their average.

I am using the subtotal function to average their hours and that works fine. BUT...my boss doesn't want to see 4 rows for each person. He just wants to see one row for each person and when I collapse the rows, it only shows the employee's ID, not the name (because that's what I told the subtotal function to do...add subtotal after every change in employee ID).

name appears instead of the employee ID? That's useless to him because he hasn't memorized all the Employee's IDs.

View 13 Replies View Related

Warning Sometimes Appears

Oct 24, 2007

I have an Excel file that contains macros that I made. Sometimes when I open the file I do not get prompted to enable macros. I DO want to get prompted so I can enable the macros. Any idea why this happens? By the way, my macro security is greyed out so I cannot change it.

View 3 Replies View Related

Macro Recorder Appears

Jun 10, 2009

I used macro recorder, and this code was the result. Is there a way to shorten this code up? The more I use macro recorder, the more I'm beginning to realize that the code generated from macro recorder can be very sloppy.

View 8 Replies View Related

Different Value Every Time Certain Value Appears In Column

Dec 22, 2011

I'm putting together some data for a pivot table.

In Column Q I have a list of products. In column E these products are listed a number of time (depends on the number of regions which may change). What I am looking to do is have column A show "1" the first time the item group is in the list, "2" the second time...up to 12. Basically I'm looking to have a month (#1-12) appear in column A next to the item. If there are 3 regions then then each item will appear in the column E list 3 times. I'd like each group of 3 items to have a "1" the first time they appear, "2" the second...etc.

Here's an example....

1 - Item#1
1 - Item#1
1 - Item#1
1 - Item#2
1 - Item#2
1 - Item#2
2 - Item#1
2 - Item#1
2 - Item#1
2 - Item#2
2 - Item#2
2 - Item#2
3 - Item#1
3 - Item#1
3 - Item#1
3 - Item#2
3 - Item#2
3 - Item#2

View 2 Replies View Related

MIN Appears As 0 With Blank Cells

Feb 15, 2007

I am trying to use a MIN() function on a row of numbers; the row is not completely full (some days data was not recorded) and when I have a blank cell, the result in the MIN() frame is 0.0. This is unless of course I have a negative number (which I don't, but for the sake of argument)

This is my current function:

{=MIN(IF(AND(MOD(COLUMN($D10:$DL10),5)=1,CELL("CONTENTS",($D10:$DQ10))0),$D10:$DL10))}
It works like:
Take every 5th column starting at the second.
Try to ignore any cell that contains 0. (This I am trying to get to filter out the empty cells; I have tried ISBLANK(), ISNUMBER() and still get nothing)
Then return the cell to the MIN() function.

That is the long winded thing of it all, basically it can be summarized as this:

{=MIN(D10:DL10}
I have also tried some other code which I was told did the same thing essentially (which it does) but is shorter and nicer:

{=MIN(IF($B$5:$DQ$5="Q*",$B10:$DQ10))}
Which will check for the proper heading on each Column.

These functions work fine with AVERAGE/MAX as far as I can tell, just not with MIN().

As a side note, none of the cells leading up to this function contain "0".

View 9 Replies View Related

Determine Last Row That A Specific Value Appears In

Dec 23, 2008

I have a range ie C2:D400.

The word "ball" appears many times in this range. How do I determine the last row that "ball" appears in?

View 9 Replies View Related

Strange Characters Appears

Sep 16, 2009

there is a strange character that appears in an excel spreadsheet. It looks like a square with a question mark in it.

what this means and am I able to remove them

View 9 Replies View Related

Picture Appears As Black Box

Dec 9, 2006

I have imported a jpeg graphic and it appears in excel as a black box. What can i do to rectify this?

View 4 Replies View Related

Highlight When Certain Text Appears

Dec 23, 2006

I tried using Conditional Formatting, but for some reason it didn't work. I want a cell to be highlighted and/or bolded when particular text is written. It can be in any cell. This can also include blank cells (if possible within a given area such as 20 cells by 20 cells)

View 3 Replies View Related

Bar Chart Appears As Thin Line Instead Of Bar

Mar 20, 2014

I am in the process of developing a tool to generate Bar charts for a set of metrics data. PFA the screenshots for the bar charts. enough spacing is needed in the bars.

ActiveChart.ChartType = xlColumnClustered

i had also axes.group=2 secondary axis.

View 2 Replies View Related

How To Skip Cells That Appears As Blanks

Apr 30, 2014

The spreadsheet that i use includes a table that some of the cells are displayed as blanks( include an IFERROR function ) I need to calculate the XIRR for a range of cells in a row that includes some of these "Blank" cells

View 2 Replies View Related

Date Appears As Number When Add Text To The End?

Jun 9, 2014

I am trying to have my cell show a range of dates, like:

5/25/14 - 5-27/14

I'm trying to use a formula like:

=DATE(2012,5,9) & " - " & DATE(2012,5,9)+2

But when I do this it just appears as:
41038 - 41040

Is there any way to tell excel to format these as dates?

View 2 Replies View Related

Formula For Most Times Name Appears And Percentage

Dec 19, 2013

The attached spreadsheet is a sample of a master sheet I need to maintain. Keep in mind that the spreadsheet has hundreds of names on it and 10 sheets in the workbook. What name appears most in the "person who called" column, then I need to know out of all the people who called, what percentage of calls he made....

I have to do this on each sheet, so if it is possible to have it work for all the sheets.

View 6 Replies View Related

SUMIF When Text Appears Anywhere In The Cell?

Feb 5, 2014

I would like to use a formula that will pull values into a sum where the values are in a column and the category is in another column. The criteria in the text cells could be located anywhere in the cell.

Example:
Column A Column B
xyzyszt (Baseline) 7890
wrxyz4sdtr (Strategic) 1234567
zecgjioae (Baseline) Infrastructure 71235
qpielcmjj ae (Strategic) New Capability 278332

View 2 Replies View Related

Text Appears When Hiding Column

Jan 30, 2008

When I hide a column in this spreadsheet, text appears in some of the cells that shouldn't be there. When I highlight and try to delete, it won't delete and it doesn't even show up in the function bar. I was able to get it to delete when I do clear, all from the edit menu but as soon as I try formating the cell, it puts it right back. Same text, same formatting. I can't get rid of it.

View 10 Replies View Related

0 Appears For Linking Blank Cells

May 25, 2008

I am linking several cells in Sheet1 to other sheets throughout the workbook. Sheets2-10 to be exact. The problem is when no data is in a given cell in Sheet1 a '0' shows up on the linked cell in Sheet2-10. The problem is 0 can be a correct response sometimes and if 0 is always to show up someone is going to misunderstand the task.

I just want to stop blank entries from being linked over as 0. I have a ton of cells being linked and don't want to do conditional formatting on each individual cell. Is their any easy way to stop this?

View 10 Replies View Related

Finding The LAST Time Something Appears In A List?

Apr 17, 2009

I have a list of numbers in Column A (labeled "Number"), with a list of dates in Column B (labeled "Date & Time"). Every date in Column B is unique, but some numbers in Column A appear more than once.

I am trying to create a simple formula that will automatically search for the LAST time a unique number appears in Column A (ignoring all previous instances of this number), and copy the date right next to it in Column B to another location on another worksheet.

I tried fussing with several of the built-in functions, but I really don't know what I'm doing, and the built-in help documents are filled with too much mathematical/programmer technical terminology for me to understand. All the tutorials I've looked at seem to think I want to add some numbers together, but I don't want to do any calculations!

View 4 Replies View Related

Searching How Many Times Something Appears In Spreadsheet?

Dec 14, 2012

At work I have been tasked with building a summary excel document that details people's names, grades etc. To be accurate, each person has their own positional code (a unique number), which I used in my lookup formula. After weeks of work, I have 1500 odd names down. However, this is 6 short of what I need the number to be. This is the cause of great stress,as this has to be ready on Monday, and I just don't have the time or sanity to sit there copying and pasting a number into find 1500 times to find the 6 numbers I have accidently ticked off as in the document. Therefore, it would be useful if there were some way to tell me how many times a number appears in the document. Each number should obviously appear twice (once in the data sheet, and once in the appropriate table)

View 9 Replies View Related

Userform Appears When Worksheet Is Copied

Jul 9, 2014

I have worksheets with different employees on separate tabs that are paid based on a compensation system inherent to their position and certain inputs. What I want to do is have a userform box appear whenever a worksheet is copied and allow the user to input the information unique to that employee (inputs are unique things like ID number, email, compensation rate, etc.). I know how to create a userform but how do I get it to automatically appear whenever a worksheet is copied?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved