LinkBack URL
About LinkBacks
Id like to know how i can identify all dates (DOB) from multiple column and have it all under one column in a different sheet.
I have attached a copy of the excel sheet. Hope you would help. Thank
Id like to know how i can identify all dates (DOB) from multiple column and have it all under one column in a different sheet.
I have attached a copy of the excel sheet. Hope you would help. Thank
=SUM(Sheet1!H2:J2)
in sheet2 D4 and copy down. Then format cells as date.
Do you need data or Dates from one H,I,J in one column or what you have got on Sheet2 is your desired outcome?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Well some of the date cells has the "general" formate so when i drag down that formula in second sheet, i only get dates which has the " Date " format.
=SUM(IF(ISERROR(DATEVALUE(Sheet1!H2:J2)),Sheet1!H2:J2,DATEVALUE(Sheet1!H2:J2)))
and copy down. This one is an array formula so you need to confirm with ctrl+shift+enter, then copy down.
If thee will be only one Date per row:
Array formula:
=SUM(IFERROR(--Sheet1!H3:J3,0))
Confirm COntrol+Shift+enter
Well the previous formula did not work as well. I'm using it on second attachment.
But i did notice cells that has the general formate does change its formate. Eg: I7 appears to be a date in "general format". I tried changing it to a number but it does not change..
Date%20Issue(1).xlsxPlease see attached.
Last edited by RobertMika; 11-12-2013 at 07:53 AM.
im not sure as to what i should be looking.. sorry
Sorry .
Please look now.
But i add a few more rows and drag it down only some appear, why is that ?
http://s000.tinyupload.com/?file_id=...74337815999199
I have uploaded the original file, can you run the formula and upload it back if possible, Id really appriciate it if you can because for some reason im unable to run the formula with out getting some blank cells
The file is to big for upload here.Originally Posted by vonmunchy
I do not see any new rows but a new column K with data
Try this formula
=SUM(IFERROR(--Sheet1!H2:K2,0))
in B2 of Sheet2 Confirm COntrl+shift+enter copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks