atlanta

Hi everyone, I am trying to use a version of the SUMIF function to convert 'one-way' flight segments to 'round trip' segments (e.g. sum all flights trips Atlanta - Nashville, and Nashville - Atlanta into one row 'Atlanta - Nashville'. The formulas I come up are quite extensive and long...

Hi All, Hoping someone can help me out :) I have the following lookup table. <tbody> A B C 1 Branch City Material 2 Branch1 Atlanta Paper 3 Branch1 Atlanta Cloth 4 Branch1 Atlanta Wood 5 Branch2 Boston Cardboard 6 Branch3 Dallas Plastic </tbody> I want to look up the...

I’d like to create rows of data based on the data in some other rows. Here is an esample of what I am trying to do. Comma delimitation Buffalo, 3 Chicago,2 Atlanta, 2 From those three rows, i’d Like to have the following filled out on the same sheet starting at say row 100: Buffalo Buffalo...

Hello everyone. I have a need to compare two columns of data (A1-A100 to E1-E100) however, the text in the columns is not always an exact match. Example A1= Atlanta GA 1a1 E4= GA Atlanta 1a1 I need to see if I can have Excel figure out that these are the same thing by being "close enough"...

Hi all, I have a worksheet where each row represents a location. Column C lists all of the employees at that location separated by carriage returns. Is it possible for the sheet to split out the employees and display individual lines for each employee? <tbody> Location ID Location Employees...

Hi Guys, Little problem that I've not quite figured out. Lets say I have a Sheet called "Data" which holds my source data...something like this in 3 Columns Team PointsHome PointsAway Atlanta 25 13 Buffalo 45 24 Cleveland 24 35 Dallas 13 39 So then in a 2nd sheet called "Fixtures" I want a...