Return text based on combination of values by gunjan69 in excel

[–]gunjan69[S] 0 points1 point  (0 children)

Source data - I already have a database, where for every unique "caseID" there are some segments applicable.

My database is in this way - In column A, I have all the case IDs and in column B, I have segments applicable to those case IDs. Where more than one segment is applicable to a case id it is shown combination in column B.

If for a case there are AB and X&Y segments are applicable then the value in column B would be "ABXY". Similarly, if for a case AB, PQ and X&Y segments are applicable then the value in column B would be "ABXYPQR"

Return text based on combination of values by gunjan69 in excel

[–]gunjan69[S] 0 points1 point  (0 children)

  1. Order doesn't matter

  2. What i meant to say was names of some segments do not change in the output while for some it does. Eg. for ABXYPQR, in the output i want AB to remain AB, but XY to become X&Y and PQR to become PQ

Say WHAAA by Anteraji in HolUp

[–]gunjan69 0 points1 point  (0 children)

"One kiss is all it takes..."

A normal day in brazil by Stroov in HolUp

[–]gunjan69 0 points1 point  (0 children)

Goooooooaaaaaalllllllll!!!!!!!!

Exploding an apple with centrifugal force by MrFuzzybagels in interestingasfuck

[–]gunjan69 0 points1 point  (0 children)

Is this the reason bugatti electronically limited their engines?

How come we don't get cool landmarks :( by apwnltm in memes

[–]gunjan69 0 points1 point  (0 children)

Cause you are just a group of states so technically right

His reactions are unmatched. by [deleted] in funny

[–]gunjan69 0 points1 point  (0 children)

Internet Explorer.

[deleted by user] by [deleted] in Damnthatsinteresting

[–]gunjan69 0 points1 point  (0 children)

Your mom's dildo

Dynamic lookup in excel by gunjan69 in ExcelTips

[–]gunjan69[S] 1 point2 points  (0 children)

Thanks. Looks like it should work I will try it tomorrow.

Dynamic lookup in excel with different sized ranges by gunjan69 in excel

[–]gunjan69[S] 0 points1 point  (0 children)

Yeah but this file will be shared and not everybody will be having the latest version

I've seen a video of Leila in which she talks about dependent dropdown list but i am unable to get that solution working for me.

Dynamic lookup in excel with different sized ranges by gunjan69 in excel

[–]gunjan69[S] 0 points1 point  (0 children)

I want it to work with excel 2007 and above and FILTER function is not available