Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-13-2015, 06:01 AM
Schoom Schoom is offline Which formula ??? Windows 7 32bit Which formula ??? Office 2013
Novice
Which formula ???
 
Join Date: Jul 2015
Posts: 3
Schoom is on a distinguished road
Default


Thanks, well that's my problem. Because when I look at the "attach" it asks for a URL and I don't have that - it's on my desk top .
Reply With Quote
  #2  
Old 07-13-2015, 06:12 AM
Schoom Schoom is offline Which formula ??? Windows 7 32bit Which formula ??? Office 2013
Novice
Which formula ???
 
Join Date: Jul 2015
Posts: 3
Schoom is on a distinguished road
Default

Found it !!!
So the first column Mary has 2 Jobs
John has 2 Jobs
Greg has 3 Jobs
Paul has 2 jobs

I want to get them into the same column (see second attachment).
But want a formula (if there is one) that knows "if 2 rows then XYZ ... then concatate to column C
If 3 rows (Greg) then XYZ and concatate to column C
Attached Images
File Type: jpg formula.jpg (44.7 KB, 10 views)
File Type: jpg result.jpg (36.3 KB, 10 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Which formula ??? Better formula please Haha88 Excel 2 03-01-2015 03:36 PM
help with a formula srockwell25 Excel 4 08-22-2014 02:47 AM
Which formula ??? Formula Excel Excel 1 08-14-2014 05:11 PM
Which formula ??? WHEN formula agent007 Excel 5 02-06-2014 09:20 PM
Which formula ??? Need help with a formula e_a_g_l_e_p_i Excel 14 02-07-2013 12:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft