Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2018, 02:42 PM
allex011 allex011 is offline Help with formula with more conditions Windows 7 32bit Help with formula with more conditions Office 2007
Advanced Beginner
Help with formula with more conditions
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default Help with formula with more conditions

Could someone help me solve the problem?
I have two sheets in one I have information like the first and last
name.In the second sheet I have some data checking of sex and certain
words related to sex. is there a possibility, with the help of a
formula, to see if there is a male or a female and whether
he is driving a driver A or B and that he connects certain cells
into a sentence that would be related to that man or woman
(as I put it in sheet 1 - example)?


I put the table in the attachment.
I made a mistake in book1 (attached file)example should be in f2 cell in sheet 1
Thanks in andvanced

Aleksandar
Attached Files
File Type: xlsx Book1.xlsx (11.5 KB, 14 views)
Reply With Quote
  #2  
Old 10-29-2018, 03:22 AM
ArviLaanemets ArviLaanemets is offline Help with formula with more conditions Windows 8 Help with formula with more conditions Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

It is not exactly what you asked for, but I hope it is what you really need (or at least something you get a start from).
Attached Files
File Type: xlsx LicenseInfo.xlsx (19.2 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to make sum based on multiple conditions, HELP! ilsel Excel 3 11-15-2017 02:03 AM
Using an undefined number of conditions to give a final formula Kopko Excel 0 08-22-2017 01:18 PM
Sum with conditions xling Excel 2 08-15-2017 12:16 AM
Excel Formula for Multiple Conditions & Results nowco Excel 4 03-16-2016 11:24 AM
6 conditions formula paconovellino Excel 2 03-05-2012 06:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:23 AM.


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