Search results for query: *

Anyone to help me please. Thank you PS: Last sample values have the heading: Sample value for Sheet2: It is actually: Sample value for Sheet3:

I have an Excel workbook with 2 sheets. Sheet1 has values from database1 in 'Row Format'. Sheet2 has values from database2 in 'Column Format'. Columns in Sheet1: Emp # Name Basic Salary House Rent COLA Columns in Sheet2: Emp # Name Earning ID Amount Sample value for Sheet1: 1 ABC 100 200 300...

Thanks I am using Internet Explorer 5 to check my emails from hotmail and yahoo accounts. In the hotmail.com interface, there is an Options|Help link. I clicked Options link. There is no setting option available for Message Forwarding. There is one for Message Replies. In Message Replies...

My friend sent me an email on my hotmail account. I want to forward this email to someone else. I need to hide address of my friend in the forwarded message. But when I clicked forward, an attachment line appeared with a file message.txt. In the message area; from, subject and date appeared...

Thanks TonyJollans I copied the code in a standard module and put in E2 =MenuSelections(A2,"Menu8") and copied down. The code gave most (not all) sequence numbers accurately when I used 'Super Menu' as a Base Menu ID. For example, if my highest menu urn is Menu1 and I used...

Thanks TonyJollans if there is a fixed maximum depth of, say, 3 or 4, menus then a formula is possible There is not a fixed maximum depth, but a maximum number may be assumed as 20 for example otherwise it will require code I have no problems if I need to write some VBA code will give...

Anyone to help me please. Thank you

Hi TonyJollans, (a) Are there ay duplicates? In your example you get to Menu3 by selecting #2 from Menu1 followed by #5 from Menu2. Might there also be, perhaps, an option #7 from Menu1 leading to Menu3, or some other combination? Yes, a program urn or a menu urn may be invoked from more than...

I have an Excel Sheet, in which I have downloaded menu options of an application. This application is menu-driven. Every user is assigned a menu. Each menu has serveral menu option numbers. A menu option number may lead to another menu or may call a program. I have dowloaded all menus of...

Thanks In my opinion, Invite and Add are not same. When you invite members, members are required to accept the invitation through email or through yahoo group website. But when you add members, members are added to the group without any need of acceptance from members. invite/add worked for...

Geoff, When I removed Columns C and D and then used advanced filter on 2 columns, then I got the required result: 10 of 12 records found. ??

Geoff, I checked for the sample data as well and it didn't work. I must be making some mistake: For the following file, I proceeded as follows: 1. Cell Pointer on A1: 2. Data -> Filter -> Advance Filter ... 3. Action: Filter the list in place 4. List Range: $A$1:$D$13 5. Criteria Range...

Geoff, Message in the status bar is strange for me as the records were not filtered at all. They remained 5445 and not 5444. What I did this time is that I selected Copy to another location in the action and entered $A$5448 in the Copy to box. This time I got the following message: The...

In an excel sheet, I have employee's position titles and departments. I have to find unique positions in each department. ColumnB: Position Title ColumnC: Department There are some more columns in this sheet in addtion to the above two. Sample Values are: P1 D1 P2 D2 P3 D3 P1 D4 P5 D5 P6...

I made a Yahoo Group on groups.yahoo.com website. Membership Type for the group is Restricted. I invited students to join the group. Some students are new to Yahoo Groups so they were not able to subscribe to group. Now I planned to add them myself. But when I clicked Members link, I found the...

I found the reason. When I opened my mailbox, I received a message from Microsoft .NET Passport stating the reason as follows: Verifying your e-mail address will ensure that we can respond if you contact us about a problem. In addition, some .NET Passport-participating sites may require you to...

Many thanks. It worked perfectly. One more question: When I signed on to MSN Messenger with @yahoo.com address, a pop-up window appeared as: You need to verify your email address with MSN Messenger. Click here. Do I need to perform this step? I added one contact in my contact list and it...

I have a Yahoo account having an email address ending with @yahoo.com. I need to use this address to signon to MSN Messenger. When I entered my email address and password, I got the message: The sign-in name you entered does not exist. Then I clicked the link: Don't have a Passport? Get one...

Many thanks Skip. This formula is very concise as compared to the IF statement. I also read a FAQ faq68-4725 to understand this formula. What I learned is, this formula has worked as follows in my example (correct me if this formula doesn't work like that): A B C 1 0 0 1 1 2000 0...

I have an Excel workbook with two sheets; Sheet1 and Sheet2. Sheet1 has three columns: Column A: A1 = Total Min Income A2 = 0 A3 = 80,001 A4 = 150,001 Column B: B1 = Total Max Income B2 = 80,000 B3 = 150,000 B4 = 700,000 Column C: C1 = Tax Amt C2 = 0 C3 = 2,000 C4 = 5,000 In Sheet2, Total...