I have data in col c type like this C2=jhonshon,15/06/1979
Please Login or Register to view this content.
C3 = david,1 january 1980
Etc
I want resume Age in col J with age 38 until matches in col c and in col K = count age (38,70 etc)
My codis has sukses but there ara result in col j become 800 and that is imposible
I dont know data is invalid my data so large
I want my coding add coding iff err.number <> 1 then msgbox "err number" & R.row
But i dont know to put in my codingI'
Last edited by daboho; 01-06-2018 at 09:25 AM.
I don't understand your description.
This will test if the cell value (r) has a valid date.
If it does not, it records the row number and cell value in the VBA Immediate window(Ctrl+G)
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you i want add my coding
I have data in col c as blabala,date
In col e i have data as s1,s1,s3,s3..etc
In col J = resume age,col K =.count resume age,in col L = resume all data from col E and in col M = .count (resume col e)
How to modikasi my coding
with one or two dictionary
Thank
Before
Why not just split that column with commas as the delimiter, and look at the result?
Before:
daboho,1 Jan 2000 daboho,29 Feb 2018
After:
daboho daboho 29 Feb 2018
Valid dates align right (because they are numbers), invalid dates align left (because they are text). Widen the column as necessary to see.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks