Bill Jelen

Explore MrExcel.com

A wealth of Excel knowledge at your fingertips...

Master Excel Bundle

from Bill Jelen

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Excel Daily News

with Bill Jelen

Power Excel Newsletter

Subscribe for Excel Tips »
1 - 2 times per month

2012 Excel Seminar Schedule

Wednesday, 05/23/2012 in ORLANDO FL
TAX Act Conference

Upcoming Event

Two-Hour Power Excel Webinar for St. Louis IIA
ST. LOUIS - 08/25/2022

More Events »

Featured Product

MrExcel 2022 Boosting Excel

Hot Topics

combinations generater?

07/04/2022 - (28 replies)

hi! i have 4 numbers in 4 cells: a1=1 b1=2 c1=3 d1=4 (could be also 1-2-3-3) how to generate all possible combinations of 4 numbers out of 8 (1-2-3-4-

Combining formulas

06/29/2022 - (26 replies)

I am trying to simplify an existing workbook. I have almost 1000 lines and over 50 headers so reviewing it is an eyesore. Right now I am creating two

Append sheets with a code.

06/28/2022 - (24 replies)

Hello JohnnyL. I have tested your last app with so many different data of HDFC bank and I have not faced any problem with any of them. It is just per

Stacked multiple columns into one column ignoring blank and 0

07/04/2022 - (22 replies)

Hi, this what I have got so far, I get it to stacked but it won't ignore blank (it is showing 0), I need it for older version, any suggestion please?

Function for turning cells into a list

06/30/2022 - (22 replies)

Hello all, so I need a formula to grab all of the peoples names in random cells from one sheet into another sheet while creating a straight down list

Check column and delete each row if a cell value = a string or it is empty

06/29/2022 - (20 replies)

Hi, I am trying to edit or make some old vba code work. After copying a Range from one workbook and pasting them into another (and it works) that part