Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() -- Ask the right questions you get the right answers. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well, if you describe your problem in more detail then you might get
some answers !! Have a look at SUMIF and SUMPRODUCT in XL Help. Hope this helps. Pete On Feb 23, 6:12*am, jlsflyer wrote: -- Ask the right questions you get the right answers. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well, I had to start the ball somehow, ok detail, I have been told I need to
use some type of macros to do what I want to do and not just a lookup but as you probably figured out I'm a rookie so I need more than that to go on. I want to match the date of the expense and get a monthly total seperate for business and personal, the date of the expense and get a seperate yearly total for business and personal, the type of expense and get seperate overall totals for business and personal, the type of expense and get seperate totals for the type of payment seperated into business and personal. Here is the list: Type of Expense Date Id Type of Payment Amount PersonalAutoGasoline 30-Jan-09 7 Credit Card $38.25 BusinessOfficeSupplies 31-Jan-09 9 Credit Card $25.63 BusinessAutoRepair 31-Jan-09 10 Cash $68.59 BusinessAutoGasoline 1-Feb-09 11 Check $26.14 BusinessExpenseMeal 1-Feb-09 12 Credit Card $29.58 BusinessAutoRepair 24-Jan-09 16 Credit Card $27.00 BusinessExpenseMeal 1-Feb-09 13 Check $89.63 PersonalAutoRepair 1-Feb-09 14 Debit Card $325.47 BusinessOfficeSupplies 1-Feb-09 15 Debit Card $48.93 BusinessAutoGasoline 29-Jan-09 8 Credit Card $40.00 PersonalAutoGasoline 4-Feb-09 17 Cash $20.25 BusinessExpenseMeal 1-Dec-08 2 Credit Card $32.58 BusinessAutoRepair 24-Dec-08 3 Credit Card $22.00 BusinessExpenseMeal 1-Dec-08 5 Check $72.63 PersonalBillsPhone 2-Dec-08 2 Check $105.95 Here is what I need totals for: Business - Monthly Yearly Credit Card Debit Card Cash Type of Expense Personal - Monthly Yearly Credit Card Debit Card Cash Type of Expense I didn't exactly know how to phrase this query in the opening question, sorry. J -- Ask the right questions you get the right answers. "Pete_UK" wrote: Well, if you describe your problem in more detail then you might get some answers !! Have a look at SUMIF and SUMPRODUCT in XL Help. Hope this helps. Pete On Feb 23, 6:12 am, jlsflyer wrote: -- Ask the right questions you get the right answers. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
As I feared the list got screwed up in the post, here it is again:
Type of Expense Date Id Type of Payment Amount PersonalAutoGasoline 30-Jan-09 7 Credit Card $38.25 BusinessOfficeSupplies 31-Jan-09 9 Credit Card $25.63 BusinessAutoRepair 31-Jan-09 10 Cash $68.59 BusinessAutoGasoline 1-Feb-09 11 Check $26.14 BusinessExpenseMeal 1-Feb-09 12 Credit Card $29.58 BusinessAutoRepair 24-Jan-09 16 Credit Card $27.00 BusinessExpenseMeal 1-Feb-09 13 Check $89.63 PersonalAutoRepair 1-Feb-09 14 Debit Card $325.47 BusinessOfficeSupplies 1-Feb-09 15 Debit Card $48.93 BusinessAutoGasoline 29-Jan-09 8 Credit Card $40.00 PersonalAutoGasoline 4-Feb-09 17 Cash $20.25 BusinessExpenseMeal 1-Dec-08 2 Credit Card $32.58 BusinessAutoRepair 24-Dec-08 3 Credit Card $22.00 BusinessExpenseMeal 1-Dec-08 5 Check $72.63 PersonalBillsPhone 2-Dec-08 2 Check $105.95 Here is what I need totals for: Business - Monthly Yearly Credit-Card Debit-Card Cash Type of Expense Personal - Monthly Yearly Credit-Card Debit-Card Cash Type of Expense Hopefully it comes through intact this time, if not, the sequence is: Type of Expense/Date/Id/Type of Payment/Amount -- Ask the right questions you get the right answers. "jlsflyer" wrote: Well, I had to start the ball somehow, ok detail, I have been told I need to use some type of macros to do what I want to do and not just a lookup but as you probably figured out I'm a rookie so I need more than that to go on. I want to match the date of the expense and get a monthly total seperate for business and personal, the date of the expense and get a seperate yearly total for business and personal, the type of expense and get seperate overall totals for business and personal, the type of expense and get seperate totals for the type of payment seperated into business and personal. Here is the list: Type of Expense Date Id Type of Payment Amount PersonalAutoGasoline 30-Jan-09 7 Credit Card $38.25 BusinessOfficeSupplies 31-Jan-09 9 Credit Card $25.63 BusinessAutoRepair 31-Jan-09 10 Cash $68.59 BusinessAutoGasoline 1-Feb-09 11 Check $26.14 BusinessExpenseMeal 1-Feb-09 12 Credit Card $29.58 BusinessAutoRepair 24-Jan-09 16 Credit Card $27.00 BusinessExpenseMeal 1-Feb-09 13 Check $89.63 PersonalAutoRepair 1-Feb-09 14 Debit Card $325.47 BusinessOfficeSupplies 1-Feb-09 15 Debit Card $48.93 BusinessAutoGasoline 29-Jan-09 8 Credit Card $40.00 PersonalAutoGasoline 4-Feb-09 17 Cash $20.25 BusinessExpenseMeal 1-Dec-08 2 Credit Card $32.58 BusinessAutoRepair 24-Dec-08 3 Credit Card $22.00 BusinessExpenseMeal 1-Dec-08 5 Check $72.63 PersonalBillsPhone 2-Dec-08 2 Check $105.95 Here is what I need totals for: Business - Monthly Yearly Credit Card Debit Card Cash Type of Expense Personal - Monthly Yearly Credit Card Debit Card Cash Type of Expense I didn't exactly know how to phrase this query in the opening question, sorry. J -- Ask the right questions you get the right answers. "Pete_UK" wrote: Well, if you describe your problem in more detail then you might get some answers !! Have a look at SUMIF and SUMPRODUCT in XL Help. Hope this helps. Pete On Feb 23, 6:12 am, jlsflyer wrote: -- Ask the right questions you get the right answers. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Friend ,
Thanks for Your Reply to my Mail/Proposal. My Client Wishes to Invest her Financial Estate worth $60Million in Your Country or Abroad under Your Direct Supervision, Your Assistance is therefore Needed in Receiving, Investing and Managing the $60Million in any viable and lucrative area of buisiness. You will be Paid 10% of the Total Amount, and an Additional 10% from the ROI. I will demand Your 100% Honesty, Confidentiality and Cooperation of these Matter. As my Clients Position as a Former Government Official does not Permit Her to Own or Operate an Over Sea Account or Company, as soon as You Assure me You can Work with my Terms then we can Proceed. I will want You to give Details on how You plan to Invest the Money, and what should be Expected on returns whether in Your Country or Over Sea.I shall be needing the information below to enable me carry out all relevant paper works that will back the claim of Funds. Do Confirm Your Interest by providing the Information below: Your Full Name Company Name Complete Address Direct Phone Age/Occupation I will wait to hear from You, and also provide all above Information. Barnabas Irane Phone: +229 96-333-443 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Friend ,
Thanks for Your Reply to my Mail/Proposal. My Client Wishes to Invest her Financial Estate worth $60Million in Your Country or Abroad under Your Direct Supervision, Your Assistance is therefore Needed in Receiving, Investing and Managing the $60Million in any viable and lucrative area of buisiness. You will be Paid 10% of the Total Amount, and an Additional 10% from the ROI. I will demand Your 100% Honesty, Confidentiality and Cooperation of these Matter. As my Clients Position as a Former Government Official does not Permit Her to Own or Operate an Over Sea Account or Company, as soon as You Assure me You can Work with my Terms then we can Proceed. I will want You to give Details on how You plan to Invest the Money, and what should be Expected on returns whether in Your Country or Over Sea.I shall be needing the information below to enable me carry out all relevant paper works that will back the claim of Funds. Do Confirm Your Interest by providing the Information below: Your Full Name Company Name Complete Address Direct Phone Age/Occupation I will wait to hear from You, and also provide all above Information. Barnabas Irane Phone: +229 96-333-443 |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
So true
Ask the right questions you get the right answers -- Don Guillett Microsoft MVP Excel SalesAid Software "jlsflyer" wrote in message ... -- Ask the right questions you get the right answers. |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry if I was vague Don, this should change that.
Ok, detail, I have been told I need to use some type of macros to do what I want to do and not just a lookup but as you probably figured out I'm a rookie so I need more than that to go on. I want to match the date of the expense and get a monthly total seperate for business and personal, the date of the expense and get a seperate yearly total for business and personal, the type of expense and get seperate overall totals for business and personal, the type of expense and get seperate totals for the type of payment seperated into business and personal. Here is the list: Type of Expense Date Id Type of Payment Amount PersonalAutoGasoline 30-Jan-09 7 Credit Card $38.25 BusinessOfficeSupplies 31-Jan-09 9 Credit Card $25.63 BusinessAutoRepair 31-Jan-09 10 Cash $68.59 BusinessAutoGasoline 1-Feb-09 11 Check $26.14 BusinessExpenseMeal 1-Feb-09 12 Credit Card $29.58 BusinessAutoRepair 24-Jan-09 16 Credit Card $27.00 BusinessExpenseMeal 1-Feb-09 13 Check $89.63 PersonalAutoRepair 1-Feb-09 14 Debit Card $325.47 BusinessOfficeSupplies 1-Feb-09 15 Debit Card $48.93 BusinessAutoGasoline 29-Jan-09 8 Credit Card $40.00 PersonalAutoGasoline 4-Feb-09 17 Cash $20.25 BusinessExpenseMeal 1-Dec-08 2 Credit Card $32.58 BusinessAutoRepair 24-Dec-08 3 Credit Card $22.00 BusinessExpenseMeal 1-Dec-08 5 Check $72.63 PersonalBillsPhone 2-Dec-08 2 Check $105.95 Here is what I need totals for: Business - Monthly Yearly Credit Card Debit Card Cash Type of Expense Personal - Monthly Yearly Credit Card Debit Card Cash Type of Expense Sorry, I didn't exactly know how to phrase this query in the opening question but I would appreciate any help you can give me. J -- Ask the right questions you get the right answers. "Don Guillett" wrote: So true Ask the right questions you get the right answers -- Don Guillett Microsoft MVP Excel SalesAid Software "jlsflyer" wrote in message ... -- Ask the right questions you get the right answers. |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Mon, 23 Feb 2009 07:13:16 -0800, jlsflyer
wrote: Sorry if I was vague Don, this should change that. Ok, detail, I have been told I need to use some type of macros to do what I want to do and not just a lookup but as you probably figured out I'm a rookie so I need more than that to go on. I want to match the date of the expense and get a monthly total seperate for business and personal, the date of the expense and get a seperate yearly total for business and personal, the type of expense and get seperate overall totals for business and personal, the type of expense and get seperate totals for the type of payment seperated into business and personal. Here is the list: Type of Expense Date Id Type of Payment Amount PersonalAutoGasoline 30-Jan-09 7 Credit Card $38.25 BusinessOfficeSupplies 31-Jan-09 9 Credit Card $25.63 BusinessAutoRepair 31-Jan-09 10 Cash $68.59 BusinessAutoGasoline 1-Feb-09 11 Check $26.14 BusinessExpenseMeal 1-Feb-09 12 Credit Card $29.58 BusinessAutoRepair 24-Jan-09 16 Credit Card $27.00 BusinessExpenseMeal 1-Feb-09 13 Check $89.63 PersonalAutoRepair 1-Feb-09 14 Debit Card $325.47 BusinessOfficeSupplies 1-Feb-09 15 Debit Card $48.93 BusinessAutoGasoline 29-Jan-09 8 Credit Card $40.00 PersonalAutoGasoline 4-Feb-09 17 Cash $20.25 BusinessExpenseMeal 1-Dec-08 2 Credit Card $32.58 BusinessAutoRepair 24-Dec-08 3 Credit Card $22.00 BusinessExpenseMeal 1-Dec-08 5 Check $72.63 PersonalBillsPhone 2-Dec-08 2 Check $105.95 Here is what I need totals for: Business - Monthly Yearly Credit Card Debit Card Cash Type of Expense Personal - Monthly Yearly Credit Card Debit Card Cash Type of Expense Sorry, I didn't exactly know how to phrase this query in the opening question but I would appreciate any help you can give me. J You might try looking at Pivot Tables. Here's something I put together quickly based on what you've written, but there are numerous possible variations. Amounts Dates 2008 2009 Grand Total Dec Jan Feb Bus/Personal Business $127.21 $161.22 $194.28 $482.71 Personal $105.95 $38.25 $345.72 $489.92 Grand Total $233.16 $199.47 $540.00 $972.63 If you expand any (or all) of the months, you can get a breakdown by type of payment. I didn't do it as the word wrap would make the results unreadable. Here's a partial sample just showing the Dec 2008 charges: Amounts Dates 2008 Dec Dec Total Bus/Personal Check Credit Card Business $72.63 $54.58 $127.21 Personal $105.95 $105.95 Grand Total $178.58 $54.58 $233.16 To create this, I dragged Type of Expense to Row Labels Amounts to Values Then I selected the Business types and "grouped" them Then I selected the Personal types and "grouped" them The columns I "grouped" by months and years Then I "expanded" the columns to show Type of Payment. --ron |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Ron, I need to run out and do some things right now but I'm sure I'll
have some questions for you once I disect your response and compare it to my experience level. I'll get back to you later on. Thanks again. Jon -- Ask the right questions you get the right answers. "Ron Rosenfeld" wrote: On Mon, 23 Feb 2009 07:13:16 -0800, jlsflyer wrote: Sorry if I was vague Don, this should change that. Ok, detail, I have been told I need to use some type of macros to do what I want to do and not just a lookup but as you probably figured out I'm a rookie so I need more than that to go on. I want to match the date of the expense and get a monthly total seperate for business and personal, the date of the expense and get a seperate yearly total for business and personal, the type of expense and get seperate overall totals for business and personal, the type of expense and get seperate totals for the type of payment seperated into business and personal. Here is the list: Type of Expense Date Id Type of Payment Amount PersonalAutoGasoline 30-Jan-09 7 Credit Card $38.25 BusinessOfficeSupplies 31-Jan-09 9 Credit Card $25.63 BusinessAutoRepair 31-Jan-09 10 Cash $68.59 BusinessAutoGasoline 1-Feb-09 11 Check $26.14 BusinessExpenseMeal 1-Feb-09 12 Credit Card $29.58 BusinessAutoRepair 24-Jan-09 16 Credit Card $27.00 BusinessExpenseMeal 1-Feb-09 13 Check $89.63 PersonalAutoRepair 1-Feb-09 14 Debit Card $325.47 BusinessOfficeSupplies 1-Feb-09 15 Debit Card $48.93 BusinessAutoGasoline 29-Jan-09 8 Credit Card $40.00 PersonalAutoGasoline 4-Feb-09 17 Cash $20.25 BusinessExpenseMeal 1-Dec-08 2 Credit Card $32.58 BusinessAutoRepair 24-Dec-08 3 Credit Card $22.00 BusinessExpenseMeal 1-Dec-08 5 Check $72.63 PersonalBillsPhone 2-Dec-08 2 Check $105.95 Here is what I need totals for: Business - Monthly Yearly Credit Card Debit Card Cash Type of Expense Personal - Monthly Yearly Credit Card Debit Card Cash Type of Expense Sorry, I didn't exactly know how to phrase this query in the opening question but I would appreciate any help you can give me. J You might try looking at Pivot Tables. Here's something I put together quickly based on what you've written, but there are numerous possible variations. Amounts Dates 2008 2009 Grand Total Dec Jan Feb Bus/Personal Business $127.21 $161.22 $194.28 $482.71 Personal $105.95 $38.25 $345.72 $489.92 Grand Total $233.16 $199.47 $540.00 $972.63 If you expand any (or all) of the months, you can get a breakdown by type of payment. I didn't do it as the word wrap would make the results unreadable. Here's a partial sample just showing the Dec 2008 charges: Amounts Dates 2008 Dec Dec Total Bus/Personal Check Credit Card Business $72.63 $54.58 $127.21 Personal $105.95 $105.95 Grand Total $178.58 $54.58 $233.16 To create this, I dragged Type of Expense to Row Labels Amounts to Values Then I selected the Business types and "grouped" them Then I selected the Personal types and "grouped" them The columns I "grouped" by months and years Then I "expanded" the columns to show Type of Payment. --ron |
#11
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ron, I'm sorry I haven't responded to you sooner, I had a death in the family
and I haven't had time for anything but finalizing those affairs. I had a chance to review your answer to my question and I'm trying to digest how you got to the results you are showing. Can you send me the details on how you produced those results as far as fomulas or functions. It would be very helpful. And I hope you will be patient with me I'm pretty new to Excel. Thank you. Jon -- Ask the right questions you get the right answers. "Ron Rosenfeld" wrote: On Mon, 23 Feb 2009 07:13:16 -0800, jlsflyer wrote: Sorry if I was vague Don, this should change that. Ok, detail, I have been told I need to use some type of macros to do what I want to do and not just a lookup but as you probably figured out I'm a rookie so I need more than that to go on. I want to match the date of the expense and get a monthly total seperate for business and personal, the date of the expense and get a seperate yearly total for business and personal, the type of expense and get seperate overall totals for business and personal, the type of expense and get seperate totals for the type of payment seperated into business and personal. Here is the list: Type of Expense Date Id Type of Payment Amount PersonalAutoGasoline 30-Jan-09 7 Credit Card $38.25 BusinessOfficeSupplies 31-Jan-09 9 Credit Card $25.63 BusinessAutoRepair 31-Jan-09 10 Cash $68.59 BusinessAutoGasoline 1-Feb-09 11 Check $26.14 BusinessExpenseMeal 1-Feb-09 12 Credit Card $29.58 BusinessAutoRepair 24-Jan-09 16 Credit Card $27.00 BusinessExpenseMeal 1-Feb-09 13 Check $89.63 PersonalAutoRepair 1-Feb-09 14 Debit Card $325.47 BusinessOfficeSupplies 1-Feb-09 15 Debit Card $48.93 BusinessAutoGasoline 29-Jan-09 8 Credit Card $40.00 PersonalAutoGasoline 4-Feb-09 17 Cash $20.25 BusinessExpenseMeal 1-Dec-08 2 Credit Card $32.58 BusinessAutoRepair 24-Dec-08 3 Credit Card $22.00 BusinessExpenseMeal 1-Dec-08 5 Check $72.63 PersonalBillsPhone 2-Dec-08 2 Check $105.95 Here is what I need totals for: Business - Monthly Yearly Credit Card Debit Card Cash Type of Expense Personal - Monthly Yearly Credit Card Debit Card Cash Type of Expense Sorry, I didn't exactly know how to phrase this query in the opening question but I would appreciate any help you can give me. J You might try looking at Pivot Tables. Here's something I put together quickly based on what you've written, but there are numerous possible variations. Amounts Dates 2008 2009 Grand Total Dec Jan Feb Bus/Personal Business $127.21 $161.22 $194.28 $482.71 Personal $105.95 $38.25 $345.72 $489.92 Grand Total $233.16 $199.47 $540.00 $972.63 If you expand any (or all) of the months, you can get a breakdown by type of payment. I didn't do it as the word wrap would make the results unreadable. Here's a partial sample just showing the Dec 2008 charges: Amounts Dates 2008 Dec Dec Total Bus/Personal Check Credit Card Business $72.63 $54.58 $127.21 Personal $105.95 $105.95 Grand Total $178.58 $54.58 $233.16 To create this, I dragged Type of Expense to Row Labels Amounts to Values Then I selected the Business types and "grouped" them Then I selected the Personal types and "grouped" them The columns I "grouped" by months and years Then I "expanded" the columns to show Type of Payment. --ron |
#12
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ok, I figured out how to work the pivot table, excellent recommendation.
Now...is there any way to have the pivot table update automatically when I input new numbers into the list or do I have to go back and pull up a new pivot table and specify additional cells every time? Thanks Ron. Jon -- Ask the right questions you get the right answers. "Ron Rosenfeld" wrote: On Mon, 23 Feb 2009 07:13:16 -0800, jlsflyer wrote: Sorry if I was vague Don, this should change that. Ok, detail, I have been told I need to use some type of macros to do what I want to do and not just a lookup but as you probably figured out I'm a rookie so I need more than that to go on. I want to match the date of the expense and get a monthly total seperate for business and personal, the date of the expense and get a seperate yearly total for business and personal, the type of expense and get seperate overall totals for business and personal, the type of expense and get seperate totals for the type of payment seperated into business and personal. Here is the list: Type of Expense Date Id Type of Payment Amount PersonalAutoGasoline 30-Jan-09 7 Credit Card $38.25 BusinessOfficeSupplies 31-Jan-09 9 Credit Card $25.63 BusinessAutoRepair 31-Jan-09 10 Cash $68.59 BusinessAutoGasoline 1-Feb-09 11 Check $26.14 BusinessExpenseMeal 1-Feb-09 12 Credit Card $29.58 BusinessAutoRepair 24-Jan-09 16 Credit Card $27.00 BusinessExpenseMeal 1-Feb-09 13 Check $89.63 PersonalAutoRepair 1-Feb-09 14 Debit Card $325.47 BusinessOfficeSupplies 1-Feb-09 15 Debit Card $48.93 BusinessAutoGasoline 29-Jan-09 8 Credit Card $40.00 PersonalAutoGasoline 4-Feb-09 17 Cash $20.25 BusinessExpenseMeal 1-Dec-08 2 Credit Card $32.58 BusinessAutoRepair 24-Dec-08 3 Credit Card $22.00 BusinessExpenseMeal 1-Dec-08 5 Check $72.63 PersonalBillsPhone 2-Dec-08 2 Check $105.95 Here is what I need totals for: Business - Monthly Yearly Credit Card Debit Card Cash Type of Expense Personal - Monthly Yearly Credit Card Debit Card Cash Type of Expense Sorry, I didn't exactly know how to phrase this query in the opening question but I would appreciate any help you can give me. J You might try looking at Pivot Tables. Here's something I put together quickly based on what you've written, but there are numerous possible variations. Amounts Dates 2008 2009 Grand Total Dec Jan Feb Bus/Personal Business $127.21 $161.22 $194.28 $482.71 Personal $105.95 $38.25 $345.72 $489.92 Grand Total $233.16 $199.47 $540.00 $972.63 If you expand any (or all) of the months, you can get a breakdown by type of payment. I didn't do it as the word wrap would make the results unreadable. Here's a partial sample just showing the Dec 2008 charges: Amounts Dates 2008 Dec Dec Total Bus/Personal Check Credit Card Business $72.63 $54.58 $127.21 Personal $105.95 $105.95 Grand Total $178.58 $54.58 $233.16 To create this, I dragged Type of Expense to Row Labels Amounts to Values Then I selected the Business types and "grouped" them Then I selected the Personal types and "grouped" them The columns I "grouped" by months and years Then I "expanded" the columns to show Type of Payment. --ron |
#13
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Sat, 7 Mar 2009 14:44:01 -0800, jlsflyer
wrote: Ok, I figured out how to work the pivot table, excellent recommendation. Now...is there any way to have the pivot table update automatically when I input new numbers into the list or do I have to go back and pull up a new pivot table and specify additional cells every time? Thanks Ron. Jon At least in Excel 2007, there is a change data source option which would allow you to include new rows without doing a new pivot table each time. This could be automated via a macro, if necessary. --ron |
#14
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello Jon,
Ron gave you already a solution with Pivot tables. Here is another one with VBA: http://www.sulprobil.com/html/sfreq.html Regards, Bernd |
#15
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Friend ,
Thanks for Your Reply to my Mail/Proposal. My Client Wishes to Invest her Financial Estate worth $60Million in Your Country or Abroad under Your Direct Supervision, Your Assistance is therefore Needed in Receiving, Investing and Managing the $60Million in any viable and lucrative area of buisiness. You will be Paid 10% of the Total Amount, and an Additional 10% from the ROI. I will demand Your 100% Honesty, Confidentiality and Cooperation of these Matter. As my Clients Position as a Former Government Official does not Permit Her to Own or Operate an Over Sea Account or Company, as soon as You Assure me You can Work with my Terms then we can Proceed. I will want You to give Details on how You plan to Invest the Money, and what should be Expected on returns whether in Your Country or Over Sea.I shall be needing the information below to enable me carry out all relevant paper works that will back the claim of Funds. Do Confirm Your Interest by providing the Information below: Your Full Name Company Name Complete Address Direct Phone Age/Occupation I will wait to hear from You, and also provide all above Information. Barnabas Irane Phone: +229 96-333-443 "Don Guillett" wrote: So true Ask the right questions you get the right answers -- Don Guillett Microsoft MVP Excel SalesAid Software "jlsflyer" wrote in message ... -- Ask the right questions you get the right answers. |
#16
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Friend ,
Thanks for Your Reply to my Mail/Proposal. My Client Wishes to Invest her Financial Estate worth $60Million in Your Country or Abroad under Your Direct Supervision, Your Assistance is therefore Needed in Receiving, Investing and Managing the $60Million in any viable and lucrative area of buisiness. You will be Paid 10% of the Total Amount, and an Additional 10% from the ROI. I will demand Your 100% Honesty, Confidentiality and Cooperation of these Matter. As my Clients Position as a Former Government Official does not Permit Her to Own or Operate an Over Sea Account or Company, as soon as You Assure me You can Work with my Terms then we can Proceed. I will want You to give Details on how You plan to Invest the Money, and what should be Expected on returns whether in Your Country or Over Sea.I shall be needing the information below to enable me carry out all relevant paper works that will back the claim of Funds. Do Confirm Your Interest by providing the Information below: Your Full Name Company Name Complete Address Direct Phone Age/Occupation I will wait to hear from You, and also provide all above Information. Barnabas Irane Phone: +229 96-333-443 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pull-down List | Excel Discussion (Misc queries) | |||
Pull through totals to front page | Excel Discussion (Misc queries) | |||
Ho to pull inmormation from a list? | Excel Worksheet Functions | |||
delete from pull down list | Excel Discussion (Misc queries) | |||
How do I set up a cell with a pull down list? | Excel Discussion (Misc queries) |