Browse by Tags

Importing text files in an Excel sheet

Hi there! Many times it is a newsgroup post which triggers me to do a writeup on a specific subject. This time, a user asked how he could import a csv file every month, without having to go through the hassle of renaming the file and re-defining the import settings each time. Opening the file in Excel [...] Read More...

Published Thu, Mar 03 2010 4:27 AM by Daily Dose of Excel

Filed under: Excel12, MVP, External Data, Excel 14, For Normal People

Formula Tips

Al sent me a formula to revise. Before: =IF($B11<>0,IF(OR(ISNUMBER(FIND("-",J11))=TRUE,ISNUMBER(FIND(" ",J11))=TRUE,ISNUMBER(FIND("_",J11))=TRUE), IF(ISNUMBER(FIND("-",J11))=TRUE,TRIM(SUBSTITUTE(J11,"-","")),IF(ISNUMBER(FIND(" ",J11))=TRUE,TRIM(SUBSTITUTE(J11," ","")),IF(ISNUMBER(FIND("_",J11))=TRUE,TRIM(SUBSTITUTE(J11,"_","")),TRIM(J11)))),TRIM(J11)),"") After: =IF($B1<>0...

Published Wed, Feb 02 2010 5:02 PM by Daily Dose of Excel

Filed under: Formulas, For Normal People

Using controls on worksheets

Hi all, I decided I need a bit more content on my site for the average to intermediate Excel users: Using controls on worksheets Apart from input cells chained to cells with formulas, there are other options in Excel to make your spreadsheet model more interactive. You can add option buttons, check boxes and list boxes to your [...] Read More...

Published Tue, Dec 12 2009 7:35 AM by Daily Dose of Excel

Filed under: MVP, For Normal People, ActiveX Controls, Controls

Converting Cells Formatted as Text

Excel has a Text format that can be applied to cells. When a cell is formatted as Text, anything you type in the cell will appears in the cell. That may seem obvious, but it applies to numbers and formulas too. For instance, if you type a formula in a cell formatted [...] Read More...

Published Mon, Oct 10 2009 11:45 AM by Daily Dose of Excel

Filed under: Formatting, For Normal People

Quick Counting in Excel

There are several ways to count cells in Excel. Here are a few. 1. Subtract rows This is how our grandparents did it. If your data is in one column, you can compute in your head largest row - smallest row + 1. Watch out for those off by one errors. 2. Use QuickSum On the [...] Read More...

Published Tue, Sep 09 2009 4:42 PM by Daily Dose of Excel

Filed under: For Normal People

Hide a Column

Here are three ways to hide a column in Excel. #1 Format Menu - select any cell in the column and choose Format - Column - Hide #2 Right Click Menu - select the column header (which selects the whole column) and choose Hide from the right click menu #3 Resize the Column to Zero - position your [...] Read More...

Published Thu, Sep 09 2009 5:17 PM by Daily Dose of Excel

Filed under: For Normal People

Cumulative Percent

Recently I was asked how many customers made up 25% of my sales. I listed each customer and their sales for a specified period, then sorted descending on sales. The formula in C2 is copied down for as far as the data goes. The secret is in the referencing. =SUM($B$2:B2)/SUM($B$2:$B$51) In the denominator, both B2 and [...] Read More...

Published Tue, Aug 08 2009 4:43 PM by Daily Dose of Excel

Filed under: For Normal People

Syndication

Recent Posts

Tags

News

Archives

Importing text files in an Excel sheet

Formula Tips

Using controls on worksheets

Converting Cells Formatted as Text

Quick Counting in Excel

Hide a Column

Cumulative Percent