UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Combine Multiple Formulas, Any Version    
 
   
halefamily104
post Jan 14 2020, 04:40 PM
Post#1



Posts: 529
Joined: 7-November 10



Hello UA!

I received some terrific help from UA (CheekyBuddha!) and now I need a little more. I am trying to combine this formula into one. Is this possible?

Here are the formulas:

=IF(SUMPRODUCT(--ISERROR(FIND("TX", $AA16)), --ISERROR(FIND("HV", $AA16)), --ISERROR(FIND("SRA", $AA16)), --ISERROR(FIND("GAD", $AA16)), --ISERROR(FIND("PHQ", $AA16)), --ISERROR(FIND("CSSRS", $AA16))), "", $AB16)
=IF(SUMPRODUCT(--ISERROR(FIND("TX", $AC16)), --ISERROR(FIND("HV", $AC16)), --ISERROR(FIND("SRA", $AC16)), --ISERROR(FIND("GAD", $AC16)), --ISERROR(FIND("PHQ", $AC16)), --ISERROR(FIND("CSSRS", $AC16))), "", $Ad16)
=IF(SUMPRODUCT(--ISERROR(FIND("TX", $AE16)), --ISERROR(FIND("HV", $AE16)), --ISERROR(FIND("SRA", $AE16)), --ISERROR(FIND("GAD", $AE16)), --ISERROR(FIND("PHQ", $AE16)), --ISERROR(FIND("CSSRS", $AE16))), "", $Af16)
=IF(SUMPRODUCT(--ISERROR(FIND("TX", $AG16)), --ISERROR(FIND("HV", $AG16)), --ISERROR(FIND("SRA", $AG16)), --ISERROR(FIND("GAD", $AG16)), --ISERROR(FIND("PHQ", $AG16)), --ISERROR(FIND("CSSRS", $AG16))), "", $Ah16)
=IF(SUMPRODUCT(--ISERROR(FIND("TX", $AI16)), --ISERROR(FIND("HV", $AI16)), --ISERROR(FIND("SRA", $AI16)), --ISERROR(FIND("GAD", $AI16)), --ISERROR(FIND("PHQ", $AI16)), --ISERROR(FIND("CSSRS", $AI16))), "", $Aj16)


Thanks in advance
This post has been edited by halefamily104: Jan 14 2020, 04:42 PM
Go to the top of the page
 
cheekybuddha
post Jan 14 2020, 05:17 PM
Post#2


UtterAccess Moderator
Posts: 12,079
Joined: 6-December 03
From: Telegraph Hill


What do want the result to be?

Are you trying to have one cell with the concatenated results of all the formulae?

--------------------


Regards,

David Marten
Go to the top of the page
 
halefamily104
post Jan 14 2020, 08:04 PM
Post#3



Posts: 529
Joined: 7-November 10



Hello Cheekybuddha! Yes! The formula below is for week 1. I have six weeks of the exact formula, except different cell references. I will need to combine six weeks worth of the formula below.

Is this even possible???
Go to the top of the page
 
cheekybuddha
post Jan 14 2020, 08:07 PM
Post#4


UtterAccess Moderator
Posts: 12,079
Joined: 6-December 03
From: Telegraph Hill


>> Is this even possible??? <<

Probably!

It would be easier with an example of what you see in the current cells and what you want to see in the result cell.

It's late here and I'm turning in. I'll pick this up tomorrow if no one else jumps in.

--------------------


Regards,

David Marten
Go to the top of the page
 
halefamily104
post Jan 14 2020, 08:25 PM
Post#5



Posts: 529
Joined: 7-November 10



ok! Let me send you what I have.
Go to the top of the page
 
halefamily104
post Jan 14 2020, 09:20 PM
Post#6



Posts: 529
Joined: 7-November 10



Here is a sample of what I am looking for.
This post has been edited by halefamily104: Jan 14 2020, 09:21 PM
Attached File(s)
Attached File  Example.zip ( 19.45K )Number of downloads: 8
 
Go to the top of the page
 
halefamily104
post Jan 15 2020, 05:39 PM
Post#7



Posts: 529
Joined: 7-November 10



Should I try an alternate route? Maybe VBA or something??
Go to the top of the page
 
Debaser
post Jan 16 2020, 07:34 AM
Post#8



Posts: 168
Joined: 11-October 18



If I've understood correctly, in BJ3:

=IFERROR(LOOKUP(2,1/FIND(BJ$2,$B3:$BH3),$C3:$BI3),"")

and copy across/down as needed.
Go to the top of the page
 
cheekybuddha
post Jan 16 2020, 08:32 AM
Post#9


UtterAccess Moderator
Posts: 12,079
Joined: 6-December 03
From: Telegraph Hill


@Debaser, thanks for picking this one up - I haven't had a chance to look at this yet, and I doubt I could have come up with such a succinct solution! thanks.gif

--------------------


Regards,

David Marten
Go to the top of the page
 
Debaser
post Jan 16 2020, 08:34 AM
Post#10



Posts: 168
Joined: 11-October 18



No worries. Of course, we don't know if it works as desired yet! wink.gif
Go to the top of the page
 
halefamily104
post Jan 16 2020, 09:45 AM
Post#11



Posts: 529
Joined: 7-November 10



Hi Debaser!

Checking it now!!! compute.gif
Go to the top of the page
 
halefamily104
post Jan 16 2020, 09:52 AM
Post#12



Posts: 529
Joined: 7-November 10



YAY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
YESSSSSS!!!!!!!!!!!!!!!!!!! That was it!!!!!!!!!!!!
IM SO GRATEFUL!!!!!! You have NO IDEA how much this has helped!

woohoo.gif thanks.gif pompom.gif hat_tip.gif thumbup.gif uarulez2.gif fundrink.gif


You should be in a band cause you ROCK!

THANKS SO MUCH!!!

Thank you CheekyBuddha for your help!!! It was fantastic!
Go to the top of the page
 
Debaser
post Jan 16 2020, 10:40 AM
Post#13



Posts: 168
Joined: 11-October 18



You're welcome. smile.gif
Go to the top of the page
 
cheekybuddha
post Jan 16 2020, 10:42 AM
Post#14


UtterAccess Moderator
Posts: 12,079
Joined: 6-December 03
From: Telegraph Hill


I think Debaser is a reference to a pretty cool band already (especially with that avatar!)!

--------------------


Regards,

David Marten
Go to the top of the page
 
Debaser
post Jan 16 2020, 10:54 AM
Post#15



Posts: 168
Joined: 11-October 18



Yes indeed! cool.gif
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th January 2020 - 10:48 PM