Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Please find my attachment & explain me how that may be done in a chart without being missed out even a single data. What is colored in yellow to be highlighted
When names are in different formats & need to get highlighted a set of data,
how it is highlighted in the script
how it is done as an expression
how it could be done in list box (Eg-Cust Name)
Thanks
Neville.
Try this?
LOAD CUSTOMER_NAME,
PREMIUM,
IF(Not WildMatch(CUSTOMER_NAME, '*K.T.*') AND WildMatch(CUSTOMER_NAME, '*Upasena*', '*Upsena*', 'SILVARAY'), CUSTOMER_NAME) AS ValidCust
FROM
CUST.xlsx
(ooxml, embedded labels, table is Sheet2);
What are you trying here for highlight values?
What is the condition to select names?
if you have only names and No conditions, you have to pick names manually
I need all names colourded in yellow to be highlighted
Please check my excel & what is coloured in Yellow to be picked at once. Please help me to achieve this!
Neville
Please look in to this
Regds
Neville
Dear Anil,
Please see the yellow coloured names in excel which I need to search for, Appreciate if you propose a search for this at once.
Regds
Neville
What is the criteria to search only those names?
And why this name is not highlighted - ?
K.T.UPASENA |
Thanks Vishwarath for responding!
K.T.Upasena, though ends with term Upasena, he is not falling in to my group. Only those who are coloured in yellow.
Need more info about that Group what you mean your group? Is there any other field that categorize that Group. Cos the information is insufficient to work on this logic rather than doing hardcode searching for these names if we have any specific rule it would be easy to work on.