Top Users by Points
John_Ru
6142 pts
Variatus
4889 pts
don
1989 pts
WillieD24
547 pts
queue
467 pts
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel Q&A Forum

Newest Selected Answer 'formulas-functions' Questions

Microsoft Excel Question & Answer Forum.

Ask Question
View All Possible Tags
+
Sorting columns to include cells with duplicate contents.
excelformulas-functionsvlookup
asked: Jun 16, '19 at 2:37 pm | by: MrEMann (rep: 20)
Answer Selected Answers: 1
Vlookup to get Named Range
excelformulas-functionsvlookupnames
asked: Jun 12, '19 at 12:04 pm | by: amberella23 (rep: 2)
Answer Selected Answers: 1
Dynamic Range
excelformulas-functions
asked: May 5, '19 at 5:05 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
COUNTIFS
excelformulas-functions
asked: May 4, '19 at 2:48 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
Vlookup Match on two columns
excelformulas-functions
asked: Apr 12, '19 at 1:14 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
Extract digits
excelformulas-functions
asked: Apr 2, '19 at 6:12 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
MATCH WITH WILD CARD
excelformulas-functions
asked: Mar 30, '19 at 6:35 pm | by: carroll (rep: 16)
Answer Selected Answers: 1
Scan a column and sum values in other column
excelmacros-vbaformulas-functionsuser-defined-functions-udf
asked: Mar 9, '19 at 10:03 am | by: Michael_Php (rep: 4)
Answer Selected Answers: 1
Using INDEX/MATCH across workbooks with totals and dates
excelformulas-functions
asked: Jan 28, '19 at 3:13 pm | by: Schneids (rep: 2)
Answer Selected Answers: 2
COUNTIFS - multiple resets on value
excelformulas-functions
asked: Dec 25, '18 at 2:21 am | by: Lightkeeper (rep: 2)
Answer Selected Answers: 1
Percentages in Individual Rows and Overall do not tally
excelformulas-functions
asked: Dec 21, '18 at 9:54 am | by: askexcel (rep: 2)
Answer Selected Answers: 2
Array Formula
excelformulas-functions
asked: Dec 20, '18 at 8:23 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
User Input Lookup Table Array Formula
excelformulas-functions
asked: Dec 10, '18 at 8:49 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
User Input Lookup Table
excelformulas-functions
asked: Dec 7, '18 at 5:09 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
Pull Data based on two criteria
excelformulas-functions
asked: Nov 27, '18 at 5:32 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
If Error Match
excelformulas-functions
asked: Nov 21, '18 at 3:54 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
How to convert TXT file to Excel and match data
excelformulas-functionsimport-export
asked: Nov 20, '18 at 3:38 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
Match based on three criteria
excelformulas-functions
asked: Nov 19, '18 at 2:56 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
Find Duplicates based on two ranges
excelformulas-functions
asked: Nov 19, '18 at 2:36 pm | by: Sroncey21 (rep: 66)
Answer Selected Answers: 1
Adding Uncleared Charges
excelmacros-vbaformulas-functions
asked: Oct 24, '18 at 4:12 pm | by: ironsprings (rep: 2)
Answer Selected Answers: 1
Extracting
excelformulas-functions
asked: Sep 27, '18 at 9:42 pm | by: Kenny (rep: 2)
Answer Selected Answers: 1
REVISED Inserting/Copy/Paste A Row > 2 Conditions, Loop VBA
excelmacros-vbaformulas-functionsformatting
asked: Sep 20, '18 at 3:58 pm | by: CoraG (rep: 6)
Answer Selected Answers: 1
IF statement and dates
excelformulas-functions
asked: Sep 18, '18 at 1:51 pm | by: ng1031 (rep: 2)
Answer Selected Answers: 1
How to vlookup keyword within text string
excelformulas-functionsvlookup
asked: Sep 4, '18 at 7:34 pm | by: syah1606 (rep: 2)
Answer Selected Answers: 1
change value of specific cell based on which cell is selected
excelmacros-vbaformulas-functionsdata-analysis
asked: Sep 3, '18 at 3:27 pm | by: KyleSC (rep: 4)
Answer Selected Answers: 1 | Votes: 1
IF statement help - checking for negative values and equal values
excelformulas-functions
asked: Jun 28, '18 at 9:58 am | by: ira (rep: 2)
Answer Selected Answers: 2
Conditional formatting for cells in a column that contain formulas but have no values/are blank
excelformulas-functions
asked: Jun 8, '18 at 1:45 pm | by: Hedy (rep: 5)
Answer Selected Answers: 2
How to get variables linked to a dollar amount and then added to a different colum
excelformulas-functionsfinanceformattingtext-manipulation
asked: Jun 7, '18 at 12:07 pm | by: ashbigs (rep: 2)
Answer Selected Answers: 1
How to calculate revised gross pay with rating criteria?
excelformulas-functions
asked: May 25, '18 at 11:55 am | by: Akash Sharma (rep: 40)
Answer Selected Answers: 1
How do I create a button and use it to generate an ascending sequential reference number on a worksheet?
excelmacros-vbaformulas-functions
asked: May 15, '18 at 6:26 am | by: Blue Owl (rep: 2)
Answer Selected Answers: 2