Recent content by sifar786

It seems nobody seems to know of this issue, on this forum. :rolleyes:

Hi, I have attached a sample file with my code in it. What i am trying to do is Superscript the Letters only and not the numbers. Interestingly, the code does superscript each data label correctly, but once it moves to another datalabel in the same series or other series, it seems to...

hi, i am trying to Superscript the a portion of the text in datalabels in a chart placed on a worksheet. Set dl=Cht.SeriesCollection(j).DataLabels dl(i).Characters(Start:=LStart, Length:=1).Font.Superscript =msoTrue but it seems to Superscript the entire data label text. Also it seems to...

hi, changed formula this way: {=IF(ISERROR(INDEX($F$2:$H$6,SMALL(IF($A$2=$E$2:$E$6,ROW($E$2:$E$6)-ROW($E$2)+1),ROW($E$2:$E$6)-ROW($E$2)+1),$B$1)),"",INDEX($F$2:$H$6,SMALL(IF($A$2=$E$2:$E$6,ROW($E$2:$E$6)-ROW($E$2)+1),ROW($E$2:$E$6)-ROW($E$2)+1),$B$1))} :)

Hi, I have a table like this: i want to populate a data validation list using a named range created by filtering values in above table on below 2 criteria: Services : Service2 Country : Country3 I am trying something like this which is not working properly...

Hi Atul Rajratna, the formula posted by Luke M is an array formula. as such you need to press F2 and then Ctrl-Shift-Enter for the dates to appear. Cheers! :)

Thanks Luke, finally someone was able to find a cure. :) Cheers Luke! You are a true Ninja!! :)

hi Prasaddn, to answer your question, the rng1,rng2,rng3 are holiday ranges for every country. as such they are put in different columns so that a combination of country holidays can be feeded to the WORKDAY function. as for pressing F9 for getting the array values for the dates, i already...

Hi, I am trying to find out a way to join a number of holiday ranges (defined names Rng1,Rng2,Rng3) lying in different columns into a single range and feed it to the WORKDAY function. however the WORKDAY function does not seem to work. used it as an Array, still not working...

Excellent Luke, this is awesome! Though a workaround for double-letters considering condition #3 would be better, this definitely does the works for singular letters. Thanks and best regards. :)

Hi Luke, Thanks for explaining in a simplistic manner :) So, what i infer is that these functions won't work for letters like AA, AB, CD, CF etc? And can i call these in a worksheet_Change event by passing them a cell range, so that user can type in letter/number in either column 1 (or...

Hi Luke, Could you explain me both these codes as its not commented? for e.g. why are you incrementing i = i + 3 in the Do Loop? Thanking you in advance :)

Hi, I have a table consisting of 2 columns: blockquote Cell Letter Cell # A 1 B 2 C, D 3, 4 E, F, G 5, 6, 7 H 8 I 9 J...

Hi Luke, I have already tried that option, but it does not seem to align the x & y axis to the vertical and horizontal edges of the picture. If you want, i can post a sample for you to see the code.

Hi, I am trying to properly align an embedded XY Scatter chart in a sheet, to a background picture, but the chart plotarea does not coincide with the picture. It keeps on shifting. I have tried Dick Kuslieska's example to pin the chart and picture edges to worksheet cells, but it does not seem...