Unable To Get Proper Merged Results

macropod · #16 04-12-2016, 02:06 PM

Quote:

Originally Posted by JennEx

Where did you put the new version (data file or report file) ...?

I simply replaced the attachment in post #12.

Quote:

Originally Posted by JennEx

And so we're on the same page, (I'm guessing you have reason behind your approach), but I don't seem to be having issues with the time fields. It's the others line: r#_relchg, r#_crew, r#_division, r#_base and r#_pitch that are being represented improperly in the report.

Yes, but you're also getting time outputs in cells that don't have them:

Quote:

Originally Posted by JennEx

For example, the boxes under "CHANGE" shouldn't have any time values in them which a couple do (They are supposed be be simply "r#_division r#_base/r#_pitch ... Bantam 82'/55', not )

.

Quote:

Originally Posted by JennEx

I wonder ... the text values in the data for r#_base and r#_pitch include an apostrophe. (82', 55'). Might this be causing issues?

Possibly, in which case we might need to insert a dummy data row at the top of the worksheet, which we can then use a SKIPIF field to exclude from any outputs.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
proper	snoforlife	Excel Programming	0	01-26-2016 02:16 PM
Hyperlinks Not Linking to Proper Sections of Doc	MoiraB	Word	2	08-26-2015 07:13 PM
Table will not allow sorting because "cells are merged". I can't find the merged cells.	wendyloooo	Word Tables	1	05-26-2015 01:19 PM
Proper Text Format	sufian,naeem	Excel	1	05-05-2014 05:59 AM
2013 search results take a long time - they fill in as results in reverse date order	themookman	Outlook	0	10-11-2013 12:01 PM