• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Challenges

Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here!
Hui
  • Sticky
Excel 4th Dimension Challenge
Replies
0
Views
2K
Hui
Hui
bobhc
  • Locked
  • Sticky
File UPLOAD
Replies
0
Views
4K
bobhc
bobhc
Hui
  • Locked
  • Sticky
Excel Challenges - Forum
Replies
0
Views
5K
Hui
Hui
J
Multiple Payments One Invoice
Replies
1
Views
450
vletm
V
D
parse cell without array formula
Replies
12
Views
5K
AliGW
AliGW
jeffreyweir
Formula Challenge 001 - Return everything in string after first block of numbers
2 3
Replies
64
Views
15K
Peter Bartholomew
P
B
Pairs of numbers
2 3
Replies
61
Views
13K
Peter Bartholomew
P
H
Formula Challenge 021 - SUMIF in Merged cells.
Replies
23
Views
16K
Peter Bartholomew
P
iferror
Formula Challenge 023 - IMEI Luhn Check
2
Replies
31
Views
25K
p45cal
p45cal
jeffreyweir
Formula Challenge 012 - Turn a mixed 2-d array into a 1-d array.
2
Replies
31
Views
16K
Peter Bartholomew
P
V
Complex Excel Formula Required
Replies
5
Views
427
Peter Bartholomew
P
B
Payback period
Replies
23
Views
7K
GAM
G
A
  • Locked
HIDING
Replies
1
Views
437
vletm
V
B
Cars advertised -- Analyst Dashboard
Replies
11
Views
829
vletm
V
S
  • Locked
Excel 2019 - "Artificial" Grand Total Row on Top of Pivot / Slicers
Replies
2
Views
850
vletm
V
H
  • Locked
Bank Recon where date and amount is common & Bank provide single entry for bulk transaction & in books we record in each entry individually
Replies
4
Views
940
vletm
V
T
  • Locked
Excel Data in Kannad (Nudi font) Language need translation in English in excel
Replies
1
Views
739
vletm
V
N
Need Help for Employee Leave Tracker
Replies
4
Views
2K
samsonto
S
P
Sorting a list of comma-separated lists
Replies
23
Views
8K
salim hasan
salim hasan
S
  • Locked
Auto allocation of work schedule
Replies
2
Views
2K
vletm
V
P
  • Locked
Doubt in Proportional allocation
Replies
2
Views
1K
vletm
V
M
  • Locked
Departmentwise Powerpoint Presentation files from a commom Database in Excel
Replies
2
Views
1K
vletm
V
K
Suggest alternate Formula..for large number
Replies
6
Views
2K
kundanlal
K
Sam Mathai Chacko
Formula Challenge 024 - Sum Of Items Based On Hierarchy Level
Replies
17
Views
9K
mungunbayar
M
B
Find the minimum every line, and summarize.
2
Replies
27
Views
12K
Peter Bartholomew
P
S
  • Locked
Color codes variance in a sentence
Replies
1
Views
2K
vletm
V
L
Formula Challenge 022 - Find the item with the largest sum in a list
2
Replies
39
Views
16K
Peter Bartholomew
P
J
Data Extraction excel challenge
Replies
10
Views
5K
Peter Bartholomew
P
B
Add space between digits
Replies
6
Views
4K
NPOKALA
N
P
How would you define a relative dynamic range
Replies
17
Views
4K
GraH - Guido
GraH - Guido
P
Evaluate the material on a chess board
Replies
15
Views
3K
Peter Bartholomew
P
chirayu
Something I found on Ozgrid
Replies
14
Views
4K
Peter Bartholomew
P
B
Find a series of numbers that appear in any order
Replies
24
Views
4K
Peter Bartholomew
P
L
Phase 2: Break The Code
Replies
8
Views
2K
chirayu
chirayu
L
Break The Code
Replies
6
Views
2K
Logit
L
B
What are 5 numbers in the highest frequency,
Replies
10
Views
4K
cooper
C
XLPadawan
Poker Hand-Dealing Simulation
Replies
1
Views
4K
Hui
Hui
jeffreyweir
Formula Challenge 010 - Two-way interpolation.
Replies
16
Views
12K
Galen
G
David Hager
CreatE A Unique Delimited String From a Delimited String – Excel Formula Method (by David Hager)
Replies
2
Views
5K
David Hager
David Hager
S
  • Locked
Create a dynamic chart for the number series and series ranges
Replies
2
Views
3K
Hui
Hui
B
Find the minimum every line, and summarize 2
Replies
14
Views
5K
Ufoo
U
S
Formula Challenge 009 -The Difference between the Latest and Earliest instance
Replies
13
Views
6K
Subrat Mandal
S
XLPadawan
Multiplication Table with minimal typing
Replies
4
Views
3K
XLPadawan
XLPadawan
B
Find the cumulative amount
Replies
15
Views
6K
bines53
B
B
A combination of three tables gives the amount 20
Replies
6
Views
4K
Asheesh
Asheesh
E
Find the word
Replies
9
Views
4K
Khalid NGO
Khalid NGO
E
Challenge ex.2 Repeat series of numbers
Replies
5
Views
4K
r1c1
r1c1
Asheesh
Shorter & Efficient Formula: Unique Count of Matching values between Two Variable length Lists
Replies
9
Views
4K
Deepak
Deepak
John Jairo V
Formula Challenge 025 - Calculation Interval Hours
2
Replies
25
Views
8K
alphamax
A
jeffreyweir
Formula Challenge 011 - distinct/duplicate/unique array from text AND numbers
2
Replies
43
Views
15K
Faseeh
Faseeh
shrivallabha
Formula Challenge 020 - Conditional COUNT
Replies
10
Views
5K
shrivallabha
shrivallabha
Sajan
Formula Challenge 003 - Count unique characters common to two strings
Replies
15
Views
10K
Haseeb A
H
Luke M
Formula Challenge 004 - Add and subtract days to pre-1900 dates
2
Replies
32
Views
9K
jeffreyweir
jeffreyweir
You must log in or register to post here.
Back
Top