Formating First Name and Last Name

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Getting Duplicate items when adding to toolbar This seems to happen when a user logs onto a PC and launches Excel 2003 for the first time. When I go into customizing the tool bar, the item that I wanted to add to the toolbar in the first place, appears (i.e. Sort Descending). Since it looks like it's already on the toolbar, I click Close. That item disappears and is not on the toolbar any longer. So I go back in and add the item to the toolbar so that now it is displayed twice (also shows twice after clicking Close). Then, I'll go back in and delete one of the duplicated items and when I Close, either both will disappear or just one displays (as desired). Is this a bug? Has someone else experienced this? Is there something I should be doing differently? Tag: Formating First Name and Last Name Tag: 783704
  - 2
    - power loss, how do retrieve lost data from excel? power loss, how do retrieve lost data from excel? Tag: Formating First Name and Last Name Tag: 783702
  - 3
    - Formulas based on Pivot Table I believe this is possible but I can't remember how I did it in the past... I have a pivot table that has formulas to the right and depending on the filter I use I can have anywhere from 5 rows of data to 30,000 rows. How can I have the formulas only appear where there is data? So if I have 5 records I would have 5 rows of formulas and if I have 30,000 records I would have 30,000 rows of formulas. Is this possible? -- Thank You, Steve Tag: Formating First Name and Last Name Tag: 783700
  - 4
    - Calculating bonuses - but not a VLOOKUP or CEILING? I have a big PivotTable of sales of specific products against salespeople. Product Salesperson1 Salesperson2 product1 1 5 product2 0 11 product3 6 2 product4 3 6 Salespeople are paid a bonus if sales are in multiples of 5 - they get no bonus for selling 0-4 units. A 5 euro bonus for selling 5, 6, 7, 8 or 9 units. Then 10 euro for shifting 10, 11, 12, 13, or 14. Then a 15 euro bonus, etc. So in the above examples, Salesperson1 would get 5 euro total. Salesperson2 would get 20. I can copy out the pivot results to another sheet and insert a column for each salesperson that runs a CEILING formula against each adjacent cell. Then sum the ceiling column for each salesperson, getting their total bonus. This works fine. I also ran a VLOOKUP, which worked a-ok too. But there are a lot of columns to insert. What single cell formula would I enter underneath each salesperson's column that could calculate their total bonus? Joe. Tag: Formating First Name and Last Name Tag: 783697
  - 5
    - CCR Clustering I have a question regarding the Public/Private IP setup for the CCR. They say that you have to setup both a Private and Public IP adapter on each node. Does that mean that I have to setup another VLAN on each network for this Private network? There is a different setup on 2008 than 2003 and Iâ??m confused as to how it should work. Also, during the CCR setup, you have to assign an IP address to the Cluster. Is this a public address? If so, how do I decipher which subnet it belongs in? Obviously the nodes will be in different subnets as the will be in completely different geographical locations. Thx Rafavic Tag: Formating First Name and Last Name Tag: 783690
  - 6
    - how do you adjust scaling for multiple tabs all at once I have about 20 tabs that I would like to adjust the margins and the fit on one page feature all at the same time. Wondering if it can be done. Working with Excel 2000 Tag: Formating First Name and Last Name Tag: 783688
  - 7
    - save each sheet of a workbook as its own workbook I have a spreadsheet with a list of reports for each department of the office I work in, each department's list is on its own tab. Is there an easy way to export this workbook so that each sheet is its own seperate workbook? this way I can email a department only their list without them getting every other department's info? I don't want to have to copy each sheet into a blank workbook and save it that way. Tag: Formating First Name and Last Name Tag: 783687
  - 8
    - Tabbing thru User-Edit Cells in Protected Sheet In a protected spreadsheet I have allowed user-edit for a range A10:B20. However when the user tries to tab from A10 to B10; the tab does not take them to column B. How can I configure the user-edit cells so that the user can tab from column A to column B? Thanks Tag: Formating First Name and Last Name Tag: 783686
  - 9
    - QAT Buttons and Ribbon Issues in Excel 2007 Hi Can someone confirm 2 things for me: 1. If you add a button to the QAT and get the green image that the only way to modify this is through code of some shape or form. I can't just right click and change it for example. 2. On my Home ribbon the Font Section has completly disappeared and the Cell Style option has expanded into loads of detail. I have loads of room on my monitor so screen size is definitely not an issue. The font section is definitely gone. I though you couldn't customise the ribbon in any way. Thanks a million. Ailish Tag: Formating First Name and Last Name Tag: 783679
  - 10
    - how to make cell turn red or green? Please help... In a row I have a one cell which is drop down list so I can choose a) or b) value. How can I make thet if I choose a) value, whole row turn green, or when I choose b) value, whole row turn red? Thanks... Tag: Formating First Name and Last Name Tag: 783675
  - 11
    - Another question Hello all, I have another question. How to have the minimum value of a column that not includes the 0. IÂ´m trying MIN(B5:B10)... but, the formula returns the 0. Well, thanks for your attention. P.S. By the way, thanks for all the good answers. Tag: Formating First Name and Last Name Tag: 783674
  - 12
    - Meeting Request Outlook XP sending to some Hi Just wondering if I send a meeting request to a number of attendees and then at a later time go back in and want to send the same meeting to more new attendees what is the best approach because if I select the previous attendees and mark them not to receive the invite the second time round they receive a cancellation message. Thanks in Advance. Ailish Tag: Formating First Name and Last Name Tag: 783669
  - 13
    - Top 10 into a Table Hi I have a large source sheet, which has incidents raised, including details on support team, CI, Root Cause. I want to have 2 tables on a seperate sheet that shows the top 20 Root Cause Codes and top 20 CI's. Can anyone help me with a formula that will do this? Tag: Formating First Name and Last Name Tag: 783668
  - 14
    - IF and OR functions I have this formula typed into a cell: =IF((C10+B26)>180,C10+B26-360,C10+B26) AND...it works fine; however, I have to add the following parameter to the same cell: = IF((C10+B26)<180,C10+B26+360,C10+B26) Please notice the subtle differences..I am working with a global 360 degree sphere wherein when values are combined, I can be maxed at positive (+179.999) degrees or minimized at negative (-179.999) degrees. I tried the "OR" function outside my "IF" function, but all I got was "TRUE" for the answer..not an actual number. PLEASE OFFER THE CORRECT FORMULA. Thank you, FLKulchar Tag: Formating First Name and Last Name Tag: 783666
  - 15
    - EXCEL question How do I use a formula in EXCEL Conditional Formating to set a color in Cell H1 based on the text in cell B1 and the number in cell H1? If B1 = "TEXT1" and H1>"NUMBER1", then H1 RED or IF B1 ="TEXT2" and H1>"NUMBER2", then H2 RED If B1 = anything else, and H1 = anything else H1 color default white. -- Les Bogert Tag: Formating First Name and Last Name Tag: 783663
  - 16
    - Working for Some but not Others Looking to continue this research from yesterday. Any ideas why it works for some and not others? Ken -----------------Yesterday's Log-------------------------------- Hi Jim, I do have that selected on all my pivot tabs and it works fine when working from within those tabs. The problem is this.... I have a "Dashboard" tab (with =GETPIVOTDATA formulas) that acts like a summary page, so they can look at the overall picture. Now, when I click on one of the getpivot cells (on the Dashboard) it will bring me to the pivot tab where it is pulling the data from. Unfortunately, this feature/functon only works for some and not others. Hopefully I've explained it well enough. Any ideas why it works for some and not others? Ken "Jim Thomlinson" wrote: > In the PivotTable Options there is a check Box "Enable Drill to Details" that > needs to be checked. > -- > HTH... > > Jim Thomlinson > > > "Ken" wrote: > > > The situation is this... > > > > Some of the people viewing my reports can click on the individual cells/data > > value and it opens a new sheet revealing the related pivot data (or it > > directs them to my pivot table). That said, others who do the same only get > > the underlying formula displayed. It's almost like there is a feature that > > needs to be turned on or maybe a patch that needs to be installed. > > > > Can anyone tell me why some people can click to display the data and others > > can't? > > > > Appreciate the help. > > > > Ken -------------------------------------------------------------------------- Tag: Formating First Name and Last Name Tag: 783658
  - 17
    - Grouping Dates I have a spreadsheet of incidents, and am trying to perform trends on this. The spreadsheet has Incident Details with dates raised. I want to do a deliquency report which shows incidents overdue by teams, based on dates, ie 0-10 days overdue, 11-30 days etc. The sheet has a couple of thousand records, and I do not really want to manually group all these, so that I can then do a Pivot based on this. Tag: Formating First Name and Last Name Tag: 783651
  - 18
    - countif?? Hi all Looking for a formula that count's, from last cell (undifined) upwards how many cell <> from 4, which from the list below should return 3 3 5 4 5 3 4 4 2 4 3 4 4 3 5 6 4 4 3 3 4 2 3 2 tks in advance AntÃ³nio Tag: Formating First Name and Last Name Tag: 783642
  - 19
    - Excel won't calculate We have rolled out Office 2007 across the company, and this week I have had two users with the same problem. The have a calculation in a cell that the copy down. The formula is correct right down the column, i.e. A1+B1 goes to A2+B2 etc... but the value all the way down is the same as the first cell the formula is copied from. There are no absolute values in the formula. Is there a fix for the obvious bug? At present we can't trust Excel. Tag: Formating First Name and Last Name Tag: 783641
  - 20
    - Freeze panes I'm working on an Excel spreadsheet which includes a number of drop down lists. When I select freeze panes to prevent horizontal and vertical movement the drop down list optins is no longer available. Is there a solution/work around available? Tag: Formating First Name and Last Name Tag: 783638
  - 21
    - Sum of values in row if they also correspond to a month? Hi, For each product I have the date it was checked, and a value for if there are any imperfections, I want a formula that works out how many products there were with imperfections in any month. Products with any imperfections have a 1 in that box, each colum represents a product checked. Month May May May June Product has imperfection? 1 1 0 1 So I want my formula to return that May has 2 wrong products, June has 1... I thought it was going to be a simple countif, but i've tried =COUNTIF(B2:E2, B1:E1="May") and it's just returning a blank! Please help!! I've tried so many variations of formulas and not getting anywhere! Thanks Ceri Tag: Formating First Name and Last Name Tag: 783634
  - 22
    - Column headings to numbers and row headings to alphabets? Hi there, My spreadsheet has gone crazy and now the column headings are in numbers instead of alphabets and at the same time, the row headings are in alphabets instead of numbers. Can anyone advice on how to rectify this? J Tag: Formating First Name and Last Name Tag: 783633
  - 23
    - Filter - Copy info Hi I have a file that I filter. Having found the required records, is there a way to copy one of the columns data into a new column but ensuring the data gets copied into the same row as the filtered records. Normally I highlight the column of data for the filtered records Use GoTo visible cells only Copy Select first cell in next column Paste The data is pasted from that cell down but doesn't get copied into the filtered record rows. Hope this makes sense. Help!! Tag: Formating First Name and Last Name Tag: 783631
  - 24
    - A highly profitable system? RSpence Life is for living Knowledge is the key to success! http://www.forex-killer.com/?hop=rspence1 Tag: Formating First Name and Last Name Tag: 783629
  - 25
    - vlookup I have revenue numbers for 2007 and 2008 in columns, I need to do a vlookup (i think) that will classify into four columns demarking wih a check mark whether column 1 - the revenue increased, column 2 - revenue was new for 2008, column 3 - decreased and column 4 -if it decreased whetheth the business went away or sales were lower in 2008. I'm fustrated because I know what I want to do and know it's possible, but can't figure out what the formula is - help! -- Thanks, Jennifer -- Thanks, Jennifer Tag: Formating First Name and Last Name Tag: 783626
- Next
  - 1
    - Drop down list with external hyperlinks I would like to set up a data validation where the items in the drop-down list are external hyperlinks. If I put complete URLs in my list, they don't show up as active hyperlinks unless the user happens to double-click or F2 the cell to activate autocorrect and cause the link to become active. Is there any way to get an active hyperlink from a drop-down list? Furthermore, what I really like to be able to do is have the items in the list be true hyperlinks where the text is a hyperlinked label, not a full URL. That is probably not possible, but any help would be appreciated. TIA Tag: Formating First Name and Last Name Tag: 783622
  - 2
    - Minimising the Ribbon in an Auto_Open macro Hi, I am trying to get an Auto_Open macro to minimise the ribbon in Excel 2007, but the Ctrl+F1 won't appear in the macro. Can someone please let me know what I am doing wrong ? -- Thanks in advance, Jeff Tag: Formating First Name and Last Name Tag: 783620
  - 3
    - Given a VALUE in a table, ascertain RANGE in another table I have month values in cells A1:A12. I have a relative range name called Date whose refers to value is '=$A1'. So in row 7, Date refers to A7, and in row 11, Date refers to A11, etc. The values in A1:A12 are derived from a larger SourceTable on another sheet. Given Date (column A of the current row), I would also like to be able to define the cell in SourceTable, so that I can ascertain a range based on that cell. I hope that's clear, but I can explain further if required. Thanks in advance Paul Martin Melbourne, Australia Tag: Formating First Name and Last Name Tag: 783617
  - 4
    - Change in Column Width depending on whether printer is installed / Hi, I need to set a specific layout for a sheet having A4 size. By default, the rowheight=18pixels & column width=66 pixels in case the machine has printer installed. If the printer is not installed, then on opening the same excel, the row height becomes 71 pixels & row width becomes 18 pixels. WHy does this happen? Is there any way to have the same size irrespective of printer setup? Tag: Formating First Name and Last Name Tag: 783616
  - 5
    - Countdown Hi, I was wondering if anyone would be able to tell me the formula to countdown the days, hours, minutes and seconds from the time I open a spreadsheeet until a given time in the future, Cheers Tag: Formating First Name and Last Name Tag: 783615
  - 6
    - Creating a profit and loss from MSQuery Data Can someone point me in the right direction for the best way to program or formulate a profit and loss (and other financial reports) from raw data tables. For example the raw data is available via ODBC in the format of a general ledger GLACCT DESC BEGINBAL PD1BAL PD2BAL PD3BAL PD4BAL ...... 1000-00 CASH 10002.00 -20.93 23.00 16.04 100.00 2000-00 A/R 2340.00 102.03 27.42 13.49 40.59 4000-01 SALES 1992.93 999.83 288.42 100.00 4000-02 SALES 1992.93 999.83 288.42 100.00 5000-01 COGS 934.23 253.65 35.67 34.64 5000-02 COGS 934.23 253.65 35.67 34.64 6100-01 UTILITIES 100.00 100.00 100.00 100.00 6100-02 UTILITIES 100.00 100.00 100.00 100.00 ETC ETC What is the best way to build a report from this data that is flexible enough to provide a profit and loss that can be updated by simply refreshing the data query? I dont want to have to rebuild the report every time a new expense acct is added. If I am looking for something like this how should I build the spreadsheet... I am quite capable with access but I don't know how to structure this in excel would you make a sheet for the query data, then pull numbers to named ranges with vlookup from another sheet? Any thoughts or Ideas would be greatly appreciated. current ytd later I will be adding historicals Sales 1992.93 12312.10 for ytd last year 2 years ago etc COGS 934.23 6102.21 Gross Profit 1058.70 6209.89 Utilities 100.00 1200.00 ... ... Total Expenses 212.00 2400.00 Net Profit 846.70 3809.89 Tag: Formating First Name and Last Name Tag: 783612
  - 7
    - Arrow key I did something to my excel worksheet that caused my arrow key not to work anymore. I cannot move the cursor between cells. It just moves the whole page up or down. How do I get back to moving the cursor between cells? Dave D. Tag: Formating First Name and Last Name Tag: 783611
  - 8
    - 'spin buttons' & vbasic language i have posted this question B4, Norman Jones did reply, but i'm confused (not hard) Iâ??m having trouble with Normans explanation. Would it be too much to ask for a greater explanation? Iâ??m not sure where to substitute my data for that required by Vbasic. To refresh, My spin button is in sheet2 By clicking on the spin button (up) I want to copy a selected group of cells A1:Q12 from sheet1 and paste into sheet2 A5:Q17, when I spin (down) I want another group of cells to be copied. Ultimately Iâ??m looking to browse thru sheet1 by clicking the spin button up/dwn and read the selected group of cells (from sheet1) in sheet2. Iâ??m not even sure Iâ??m using the correct command (spin button) maybe thereâ??s a better way, Can you advise? -- Browny Tag: Formating First Name and Last Name Tag: 783607
  - 9
    - How to attach a file to an excel sheet? Hi there, Sorry if this question has been asked before. I got an excel file, in one of it's sheets there is a "link"/button, when I double click to that button, it open up a new excel file with content inside. I would like to know how to attach the file to a sheet like that. Thanks. -- Target_locked Tag: Formating First Name and Last Name Tag: 783604
  - 10
    - Problems with trendline equations I have several worksheets of data. I am plotting/trending the data on separate worksheets, and calculating the equations of exponential trendlines. I have as many as six trendlines per graph. As I add more worksheets of data and make more graphs, the graphs that I previously made become cluttered with several trendline equations. When I delete the extra trendline equations from a given graph, Excel shuts down. I am using Microsoft Office XP Standard for students and teachers version 2002. Any advice would be greatly appreciated. Thank you. I mistakenly posted this question on the Office discussion groups earlier, I'm not intentionally multi-posting! Steve Tag: Formating First Name and Last Name Tag: 783599
  - 11
    - Sum Formula for cell range How do I multiply a number in a range of cells by a number? EX Cell 200 Multiply by 2.25 Tag: Formating First Name and Last Name Tag: 783597
  - 12
    - where do I find capital leasing calculators? where do I find capital leasing calculators? Tag: Formating First Name and Last Name Tag: 783596
  - 13
    - Can I use conditional formatting to scale a display value? I have a value in a cell, I would like to display the value directly with a text modifier if it is above a certain threshold or display a scaled value with a different text modifier if it is below a threshold. I use the value in a different calculation so I don't want to change the value of the cell, only the way it displays. Examples: If the value is time: .5 should read as "4 hours" while 2 should read as "2 days" If it was money: .5 should read as "50 cents" while 2 should read as "2 dollars" Thanks. Tag: Formating First Name and Last Name Tag: 783595
  - 14
    - Quick Sumproduct vs Text return Hi Team, I think I've lost it :P I've got two lists. c d e 9 Morry 2000 2004 10 Howie 2005 2009 11 Johno 2010 2019 12 Smithy 2020 2029 13 Jones 2030 3000 and c d 19 John 2005 20 Sam 2010 21 Ralph 2011 22 fred 2001 23 mike 2020 24 Nat 2008 25 Sally 2015 26 steff 2025 27 diane 2027 I want to pull the name from list 1 and place it in column e if the number in list 2 column d falls in the range in list1 columns d&e I have this formula working to an extent =SUMPRODUCT(--($E$9:$E$13>=$D19),--($D$9:$D$13<=$D19)*($C$9:$C$13)) This returns a #value error. if I do some checking and modify list 1 to add a unique number in column f =SUMPRODUCT(--($E$9:$E$13>=$D19),--($D$9:$D$13<=$D19),$F$9:$F$13) It returns the correct unique number..... So I figure the problem is returning the text?? Changing the forumla to this =SUMPRODUCT(--($E$9:$E$13>=$D19),--($D$9:$D$13<=$D19),$C$9:$C$13) does not work as it returns all 0. any help is much welcomed. Tag: Formating First Name and Last Name Tag: 783594
  - 15
    - How to send Excel selection using Live Mail I have been using Outlook Express until this month, and have been sending information from a selected range in an Excel worksheet to a number of people every month. I don't want to send the entire (large) worksheet as an attachment, but my "Mail Recipient" function has apparently been disabled since installing Windows Live Mail. The only "mail" option I see remaining is to mail the entire document as an attachment, which really isn't an option. Since I send this information out to about 50 recipients each month, and each recipient has different data, it's been tedious enough already. But now, I'm looking for a way to send the data using Windows Live Mail without having to cut and paste all afternoon. If there is a way to efficiently do this using a Macro, that would be even better... Thanks, Tag: Formating First Name and Last Name Tag: 783593
  - 16
    - Insert word to excel If I embed a word document, it becomes a picture of the first page of the word doc when I'm not in edit mode. I need to view the full word doc alongside the spreadsheet data. Any suggestions? Thanks Tag: Formating First Name and Last Name Tag: 783590
  - 17
    - Adding up dropdown menu categories. I created a dropdown list in my worksheet and I was wondering if there was any way to add up how many times each individual item was selected. Any help would be appreciated. Thanks! Tag: Formating First Name and Last Name Tag: 783586
  - 18
    - I need a formula that returns weekends and holidays for each mont I have created a mileage log with each month having its own spreadsheet in a workbook. The first sheet starts with February 2006 and the last sheet ends with february 2007. There are 12 sheets in total. Each month start on the first day and ends on the last day of that month. The calendar is South African. How can I create a formula that shows a Saturday, Sunday and Holiday per month. I have used =TEXT(A2, "ddd") to return days but I don't know how to create a formula that also returns holidays. Please help. Tag: Formating First Name and Last Name Tag: 783576
  - 19
    - Percentage of a Column of numbers I have a column of numbers and would like to know how many of those numbers make up 80% of the total of the column. Does anybody have a formula for that? Tag: Formating First Name and Last Name Tag: 783575
  - 20
    - where can I see my question and answer? Yesterday I ask a question I can't see my question, how can I find my question and answer Tag: Formating First Name and Last Name Tag: 783569
  - 21
    - Variance Report - Need to reflect 0% Hello! I need my variance number to show 0% even when the formula's answer is #DIV/0! Tag: Formating First Name and Last Name Tag: 783568
  - 22
    - Amortization schedule with periodic payments I have a loan, and the borrower is paying in an irregular fashion. Some months he pays and some he doesn't. How can I setup the amortization schedule to reflect this and add the appropriate interest? Thanks in advance ezy Tag: Formating First Name and Last Name Tag: 783564
  - 23
    - Disable Advanced Filter? Is there a way that I can disable the Advanced Filter option in a protected worksheet either through the UI or VBA? When I protect it I have the option to disable AutoFilter, but Advanced Filter is still available and I don't want users to have access to it. Thanks in advance! Kevin Tag: Formating First Name and Last Name Tag: 783561
  - 24
    - Copy Paste Wierdness Hello -- I have a Office Excel 2003 SP3. Here is the situation ... I have a Workbook that has many Worksheets that have some pretty intense formulas. I open a second instance of Excel with a blank Workbook. I highlight the whole worksheet and hit copy. I then Paste over on the new Blank Workbook ... and low and behold ... it is just copying the values (no formulas). If I perform the exact same test in the same instance of Excel it works fine. The funny thing is I am unable to reproduce this on other machines. Does anybody have any ideas of how this could be happening? Thanks, --Rich Tag: Formating First Name and Last Name Tag: 783560
  - 25
    - please, please help please, please help how do i get sheets, duplicated from a master sheet, to automatically number a field in each new opened sheet consequetive to the previous sheet. Tag: Formating First Name and Last Name Tag: 783559

Change: LastName, FirstName

TO: FirstName LastName

Would like to do the formatting in one equation and one step.

Re: Formating First Name and Last Name by David

David
Fri May 09 09:00:32 CDT 2008

Data/ Text to Columns/ Delimited/ by comma
--
David Biddulph

"Chico" <Chico@discussions.microsoft.com> wrote in message
news:CD2C8691-68E8-48A2-94A0-8D810E2A6E5C@microsoft.com...
> Change: LastName, FirstName
>
> TO: FirstName LastName
>
> Would like to do the formatting in one equation and one step.

Top

RE: Formating First Name and Last Name by GarysStudent

GarysStudent
Fri May 09 09:05:02 CDT 2008

=RIGHT(A1,LEN(A1)-FIND(" ",A1)) & " " & LEFT(A1,FIND(",",A1))

Thus
Ravenswood, James
will become
Janes Ravenswood
--
Gary''s Student - gsnu200785

"Chico" wrote:

> Change: LastName, FirstName
>
> TO: FirstName LastName
>
> Would like to do the formatting in one equation and one step.

Top