Group Travel and Hotel Spreadsheet

Probably not a formula, but if you tabulated it nicely you could probably use the FILTER tool or maybe a Pivot Table to get what you want.

Can you post an example spreadsheet, with the names anonymized out or something?

Depending on what your data layout looks like, you might be able to use something like a countif() based on flight number? Below is a very simplistic sample of what I mean...

	A	B	C
1	name	Flight
2	aa	123	123 4
3	bb	234	234 3
4	cc	345	345 3
5	dd	123	123 4
6	ee	234	234 3
7	ff	345	345 3
8	gg	123	123 4
9	hh	234	234 3
10	ii	345	345 3
11	jj	123	123 4

C2=B2&" "&COUNTIF($B$2:$B$11,B2)
copied down

Another option...

	A	B	C	D	E
1	name	Flight
2	aa	123		123	4
3	bb	234		234	3
4	cc	345		345	3
5	dd	123
6	ee	234
7	ff	345
8	gg	123
9	hh	234
10	ii	345
11	jj	123

D2=IFERROR(INDEX($B$2:$B$11,MATCH(0,INDEX(COUNTIF($D1:D$1,$B$2:$B$11),),0)),"")
E2=IF(D2="","",COUNTIF($B$2:$B$11,D2))
both copied down
This 1 would be more flexable, and give you a summary table

Can't seem to paste a sample, but the information I need to input is as follows (multiplied by approximately 75 people):

Name
Office
Cell Phone Number
Departure Airport
Arrival Airport
Arrival Date
Arrival Time
Airline Name
Flight Number
Drop Off Location
Departure Date
Pick Up Location
Departure Airport
Departure Time
Airline Name
Flight Number
Number of Nights in Hotel A
Number of Nights in Hotel B
Notes

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.