Search results

Thank you, Sir. In which case is there an Excel formula that can do the same ? Thank you.

CurrentAssets CurrentLiabs FractionFormat RatioFormat 1100 2400 11/24 11:24 1234 2345 10/19 10:19 Using FormatCells --> Custom --> ??/?? gives the results as shown above in FractionFormat. Instead of ??/?? i would like to use ??:?? (in the FormatCells --> Custom) but MS...

I need to use some selected symbols in a workbook for different purposes. Each symbol will be represented by a word. If i key in the word 'fwd1' the symbol '->' must appear. If i key in the word 'fwd2' the symbol '-->>' must appear. These are only hypothetical symbols......... In the workbook i...

An excel worksheet has dates for the month of April. What i would like...... hidden behind each date is the cash sales value for the day. So, if i move the cursor over a date the cash sales number for the day becomes visible (or the words 'No Sale' in case of a Sunday or Public Holiday). And if...

@Narayan: Many thanks 4 the link.

The first 20 worksheets are 'renamed' as: Advertising Biz Expenses Conveyance etc........ Worksheet21 is renamed Summary_April. Instead of retyping all renamed first 20 sheets onto sheet#21, i would like the expense names to appear in the April summary sheet in cell A1 and then drag down to...

Thank you, Faseeh. That is so perfect.

All of us are familiar with Cost of Goods Sold or COGS. Very simply put: Sales Revenue - COGS = Gross Margin. 'What-If' analysis can help look at different Gross Margin (GM) scenarios and also forecast different Net Profit scenarios by changing variables like Sales Revenues. In addition to the...

@ Narayan: Thanks.

Thank you Excel Ninjas. That was quick.! Both solutions are really smart. Stay blessed.

A data-entry operator keys in numbers from a stack of papers onto an Excel worksheet. All the numbers are 6-digits. But to err is human....... Q1-How to prevent a 6-digit number from being wrongly keyed in as 5-digit or 7-digit?? E.g....123456 could be wrongly entered as 1233456 (that's 7...

Thank you Deepak, for that link.

I'm in sheet1 that is renamed 'ExpenseMaster'. In this sheet some 20 cells have been randomly selected. Each cell has the name of an 'Expense Item' like: Conveyance Entertainment Expense Biz Travel and the like. If i click on 'Conveyance' in the Master, i would like the 'click' to 'trigger-off'...

Hello Narayan and thank you so much 4 that very clear explanation. God bless.

I'm doing a simple report of students in a Pass/Fail situaton. If a student obtains the required min marks, Excel displays a 'P' in the resp. row to indicate Pass; or 'F' to indicate Fail. The above can be done using the IF fxn. But I would like the letter 'P' to assume a green font and the...

I would like to use the 'power of Excel' to do a Cash Flow Statement that should cover: 1. Cash flow from Operating Activities. 2. Cash flow from Investing Activities. 3. Cash flow from Financing Activities. Can somebody throw in some links/formulas. That would be great. Much appreciated.

@srinidhi: Thank you. That worked fine.

Too many slices in a pie-chart to represent expense items can make the chart tOO clustered. Is there a way to circumvent the problem.??? If a slice is not easily visible is there an Excel-way (or a simple VB) to drag that slice outside of the pie-chart in order to give it more visual...

@chirayu: Thank u and thank u 4 the links.

Very many thanks guys......... @Ranjith kumar: I'm a VB aspirer and that VBA looks really good. Thank u.

I have a drop-down list of things that we sell. Sometimes due to unavoidable delays a particular item may not be available and so it becomes necessary to take the item off the list in which case i would like to use a 'strike-through' on the item (in the drop-down list) to indicate that a...

Thank u guys and bless ya. Those 2 solutions r awesome!! Also thank u guys for the examples in Excel.

I'm in sheet1. Col A1 has the label Senior_Sales_Manager. A2 thru A6 contain the names of 6 unique senior sales managers. Col B1 has the label Jan_Sales. Col C1 has the label Gold. Col D1 has the label Feb_Sales. Col E1 has the label Gold. Col F1 has the label...

Thanks, Deepak. Very much appreciated.

I need2 incorporate some data & formatting from Sheet1 thru' Sheet45. First, i open all 45 sheets. Next, click on Sheet1. Keeping the Shift button pressed, i select Sheets2 thru' 45. That's a group selection. Now that i've got my 45 sheets selected, whatever data & formatting i do in Sheet1 will...