Text & General Format to Data Format all the data - code/VBA required

V

Vishaal

Well-known Member
Joined
Mar 16, 2019
Messages
543
Office Version
  1. 2010
  2. 2007
Platform
  1. Windows
  2. Web
Hi all,

we have the following data and want to convert in "date", we have tried
Code 1 =TEXT(A1,"mm\/dd\/yyyy")+0
Code 2 =TEXT(G12,"mm/dd/yyyy")

but problem not solved, pls check the result after using the above code and provide the code/vba, also when we copy the data after using code 1, we cant get the value as data

Data

Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]its my format which I want to change in date format[/td][td]
​
[/td][td]
​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]
Date​
[/td][td]
​
[/td][td]
​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]
01-04-2019​
[/td][td]
=TEXT(A3,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A3,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]
02-04-2019​
[/td][td]
=TEXT(A4,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A4,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]
02-04-2019​
[/td][td]
=TEXT(A5,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A5,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]
04-04-2019​
[/td][td]
=TEXT(A6,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A6,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td]
05-04-2019​
[/td][td]
=TEXT(A7,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A7,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]
06-04-2019​
[/td][td]
=TEXT(A8,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A8,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]
24-09-2019​
[/td][td]
=TEXT(A9,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A9,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td]
4/5/2019​
[/td][td]
=TEXT(A10,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A10,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]
4/9/2019​
[/td][td]
=TEXT(A11,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A11,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]
4/17/2019​
[/td][td]
=TEXT(A12,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A12,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]
4/26/2019​
[/td][td]
=TEXT(A13,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A13,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td]
5/4/2019​
[/td][td]
=TEXT(A14,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A14,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td]
5/4/2019​
[/td][td]
=TEXT(A15,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A15,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td]
5/21/2019​
[/td][td]
=TEXT(A16,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A16,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td]
20-07-2019​
[/td][td]
=TEXT(A17,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A17,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td]
06/08/19​
[/td][td]
=TEXT(A18,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A18,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td]
24-07-2019​
[/td][td]
=TEXT(A19,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A19,"mm/dd/yyyy")​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20​
[/td][td]
26/09/2019​
[/td][td]
=TEXT(A20,"mm\/dd\/yyyy")+0​
[/td][td]
=TEXT(A20,"mm/dd/yyyy")​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]


Result Data
Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]its my format which I want to change in date format[/td][td]
​
[/td][td]
​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]
Date​
[/td][td]
​
[/td][td]
​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]
01-04-2019​
[/td][td]
01-04-2019​
[/td][td]
04/01/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]
02-04-2019​
[/td][td]
02-04-2019​
[/td][td]
04/02/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]
02-04-2019​
[/td][td]
02-04-2019​
[/td][td]
04/02/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]
04-04-2019​
[/td][td]
04-04-2019​
[/td][td]
04/04/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td]
05-04-2019​
[/td][td]
05-04-2019​
[/td][td]
04/05/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]
06-04-2019​
[/td][td]
06-04-2019​
[/td][td]
04/06/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]
24-09-2019​
[/td][td]
24-09-2019​
[/td][td]
09/24/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td]
4/5/2019​
[/td][td]
05-04-2019​
[/td][td]
04/05/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]
4/9/2019​
[/td][td]
09-04-2019​
[/td][td]
04/09/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]
4/17/2019​
[/td][td]
17-04-2019​
[/td][td]
04/17/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]
4/26/2019​
[/td][td]
26-04-2019​
[/td][td]
04/26/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td]
5/4/2019​
[/td][td]
04-05-2019​
[/td][td]
05/04/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td]
5/4/2019​
[/td][td]
04-05-2019​
[/td][td]
05/04/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td]
5/21/2019​
[/td][td]
21-05-2019​
[/td][td]
05/21/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td]
20-07-2019​
[/td][td]
#VALUE!​
[/td][td]
20-07-2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td]
06/08/19​
[/td][td]
08-06-2019​
[/td][td]
06/08/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td]
24-07-2019​
[/td][td]
#VALUE!​
[/td][td]
24-07-2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20​
[/td][td]
26/09/2019​
[/td][td]
26-09-2019​
[/td][td]
09/26/2019​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]
 
Last edited:

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
No, its not working, after using to above code getting the below result

9/12/3560
 
Upvote 0
If you have a mixture of dates and text in column A :

=IF(ISNUMBER(A3),A3,DATE(RIGHT(A3,4),MID(A3,4,2),LEFT(A3,2)))
 
Upvote 0
we have used this code, its fine but when we use filter for sort the month
there is problem
Its Showing February and March Month but we have not any entry on that particular month...

Pls check the #1
Result Data
A19 and A20 value after formula C19 and C20

pls check the below sheet with your formula

Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td=bgcolor:#FFFFFF]its my format which I want to change in date format[/td][td=bgcolor:#FFFFFF]
​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td=bgcolor:#FFFFFF]
Date​
[/td][td]
​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td=bgcolor:#FFFFFF]
1/4/2019​
[/td][td]
1/4/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td=bgcolor:#FFFFFF]
2/4/2019​
[/td][td]
2/4/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td=bgcolor:#FFFFFF]
2/4/2019​
[/td][td]
2/4/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td=bgcolor:#FFFFFF]
4/4/2019​
[/td][td]
4/4/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td=bgcolor:#FFFFFF]
5/4/2019​
[/td][td]
5/4/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td=bgcolor:#FFFFFF]
6/4/2019​
[/td][td]
6/4/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td=bgcolor:#FFFFFF]
24-09-2019​
[/td][td]
9/24/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td=bgcolor:#FFFFFF]
4/5/2019​
[/td][td]
4/5/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td=bgcolor:#FFFFFF]
4/9/2019​
[/td][td]
4/9/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td=bgcolor:#FFFFFF]
4/17/2019​
[/td][td]
4/17/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td=bgcolor:#FFFFFF]
4/26/2019​
[/td][td]
4/26/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td=bgcolor:#FFFFFF]
5/4/2019​
[/td][td]
5/4/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td=bgcolor:#FFFFFF]
5/4/2019​
[/td][td]
5/4/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td=bgcolor:#FFFFFF]
5/21/2019​
[/td][td]
5/21/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td=bgcolor:#FFFFFF]
20-07-2019​
[/td][td]
7/20/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td=bgcolor:#FFFFFF]
6/8/2019​
[/td][td]
6/8/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td=bgcolor:#FFFFFF]
24-07-2019​
[/td][td]
7/24/2019​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20​
[/td][td=bgcolor:#FFFFFF]
26/09/2019​
[/td][td]
9/26/2019​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

with code
Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td=bgcolor:#FFFFFF]its my format which I want to change in date format[/td][td=bgcolor:#FFFFFF]
​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td=bgcolor:#FFFFFF]
Date​
[/td][td]
​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td=bgcolor:#FFFFFF]
1/4/2019​
[/td][td]
=IF(ISNUMBER(A3),A3,DATE(RIGHT(A3,4),MID(A3,4,2),LEFT(A3,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td=bgcolor:#FFFFFF]
2/4/2019​
[/td][td]
=IF(ISNUMBER(A4),A4,DATE(RIGHT(A4,4),MID(A4,4,2),LEFT(A4,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td=bgcolor:#FFFFFF]
2/4/2019​
[/td][td]
=IF(ISNUMBER(A5),A5,DATE(RIGHT(A5,4),MID(A5,4,2),LEFT(A5,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td=bgcolor:#FFFFFF]
4/4/2019​
[/td][td]
=IF(ISNUMBER(A6),A6,DATE(RIGHT(A6,4),MID(A6,4,2),LEFT(A6,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td=bgcolor:#FFFFFF]
5/4/2019​
[/td][td]
=IF(ISNUMBER(A7),A7,DATE(RIGHT(A7,4),MID(A7,4,2),LEFT(A7,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td=bgcolor:#FFFFFF]
6/4/2019​
[/td][td]
=IF(ISNUMBER(A8),A8,DATE(RIGHT(A8,4),MID(A8,4,2),LEFT(A8,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td=bgcolor:#FFFFFF]
24-09-2019​
[/td][td]
=IF(ISNUMBER(A9),A9,DATE(RIGHT(A9,4),MID(A9,4,2),LEFT(A9,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td=bgcolor:#FFFFFF]
4/5/2019​
[/td][td]
=IF(ISNUMBER(A10),A10,DATE(RIGHT(A10,4),MID(A10,4,2),LEFT(A10,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td=bgcolor:#FFFFFF]
4/9/2019​
[/td][td]
=IF(ISNUMBER(A11),A11,DATE(RIGHT(A11,4),MID(A11,4,2),LEFT(A11,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td=bgcolor:#FFFFFF]
4/17/2019​
[/td][td]
=IF(ISNUMBER(A12),A12,DATE(RIGHT(A12,4),MID(A12,4,2),LEFT(A12,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td=bgcolor:#FFFFFF]
4/26/2019​
[/td][td]
=IF(ISNUMBER(A13),A13,DATE(RIGHT(A13,4),MID(A13,4,2),LEFT(A13,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td=bgcolor:#FFFFFF]
5/4/2019​
[/td][td]
=IF(ISNUMBER(A14),A14,DATE(RIGHT(A14,4),MID(A14,4,2),LEFT(A14,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td=bgcolor:#FFFFFF]
5/4/2019​
[/td][td]
=IF(ISNUMBER(A15),A15,DATE(RIGHT(A15,4),MID(A15,4,2),LEFT(A15,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td=bgcolor:#FFFFFF]
5/21/2019​
[/td][td]
=IF(ISNUMBER(A16),A16,DATE(RIGHT(A16,4),MID(A16,4,2),LEFT(A16,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td=bgcolor:#FFFFFF]
20-07-2019​
[/td][td]
=IF(ISNUMBER(A17),A17,DATE(RIGHT(A17,4),MID(A17,4,2),LEFT(A17,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td=bgcolor:#FFFFFF]
6/8/2019​
[/td][td]
=IF(ISNUMBER(A18),A18,DATE(RIGHT(A18,4),MID(A18,4,2),LEFT(A18,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td=bgcolor:#FFFFFF]
24-07-2019​
[/td][td]
=IF(ISNUMBER(A19),A19,DATE(RIGHT(A19,4),MID(A19,4,2),LEFT(A19,2)))​
[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20​
[/td][td=bgcolor:#FFFFFF]
26/09/2019​
[/td][td]
=IF(ISNUMBER(A20),A20,DATE(RIGHT(A20,4),MID(A20,4,2),LEFT(A20,2)))​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

when you will use filter it will show January entry but we have not any January entry in this sheet.

pls check and help
 
Upvote 0
There does not appear to be any consistency in the content and formatting of column A.
It seems that it contains a mixture of dates and numbers, and also a mixture of d/m, m/d, dd/mm, mm/dd, etc.
It's difficult to suggest a formula without knowing exactly what column A contains.

Its Showing February and March Month but we have not any entry on that particular month...
Click to expand...
Columns A and B in your last post are showing : m/d/yyyy.
So that's why February appears in the filter.
March does not appear in the data you posted, so it should not appear in the filter.
 
Upvote 0
Columns A data is main data and Columns B data is after code

i hope you can understand now
 
Upvote 0
Need to know whether each cell is date or text, and the format of each cell (e.g. d/m/y or m/d/y).
 
Upvote 0
1. DD-MM-YYYY
2. DD/MM/YYYY
3. Some cells are General
 
Upvote 0
You must log in or register to reply here.

Similar threads

SimonHughes
  • Question Question
Data Validation - Two Entries in One Cell
Replies
5
Views
198
kvsrinivasamurthy
K
M
  • Solved
Convert Date Problem
Replies
4
Views
757
Michele317
M
P
  • Solved
Lookup based on multiple criteria
2 3
Replies
22
Views
901
paulkc
P
john Smith72
  • Solved
Auto filter VBA
Replies
2
Views
364
john Smith72
john Smith72
G
  • Solved
Counting zero billing days in Excel until current date
Replies
5
Views
932
awoohaw
awoohaw

Forum statistics

Threads
1,223,894
Messages
6,175,252
Members
452,623
Latest member
Techenthusiast

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top