Search:

hi all,

i want a formula to change original data into a new layout to help me prepare a stack chart as depicted in the attachment. the formula needs to be flexible to accomedate more columns &...

many....many...thanks Steve,

thanks to the help from all,and you in particular.

dubdub

hi all,

i have a huge data that has the format in the attachment column a2:e5 that i want to expand and changed into the format g2:k10. any suggestions....

TIA

i will go aginst your expection Bob, Perfect for now, and when you have experts your demands grow. thanks to you both for the help.

thanks Kweaver & Bob, but still the condition of the count column in table 1 column "E" has to be part of the Formula, meaning the value in the range i2:07 has to agree with column "E" count value. ...

i do not know what is happening i made all the data format identical to where it works but still no sucess,attched, any help in the the two parameters/values match between the two tables i mentioned...

thanks Kweaver, i prefered using the second formula, because it covers the array value chnages, but i have two observations, the first one the g5 value is weird for unknown reason to me, all what i...

i still have hope....

thanks Bob, but if you consider the example i attached lately, it works for the first name in table-1 because there is a match in table 2 but the next name it still give a value of 2014 although the...

my appology, the attached sexample has to do the match based in two columns in table 1, column a&e with table 2 columnm h for the name and the array i3:04 for count and if match exist it will put the...

The red column represent what the formula outcome supposed to be based on the match if exist and it would read from table2

thanks Kweaver, but may be i did not describe the question enough what i am after is a formula that will match columns a&e in the first table with column h & the array i3:04 in the second table and...

i have the attached file which explain my case, i need a formula that read a specif data from table2 & align it in table 1 for the corresponding name, highlighted in red.

TIA

dubdub

it does, thanks again.

dubdub

thanks Rory, it works, is there a possibility to have a space between the text in column B.

Regards,

hi all,

say i have in column A1 a string & i wnat to search for specific strings and they are not in any specific order. for example:
column A1
mrk,wrl,fma,deen
deen,mrk,wrl...

sorry for the late reply, although i need the copy as a chart, i gave the code a try and i got a run time error '1004' with the message apple cation-defined or object-defined error.

hi all,

I have the attached table that I am trying to reformat & populate from the original one, any formula that help doing that.

TIA.

hi all

I have several worksheets that contain multiple charts. I want to copy the
charts from Excel to PowerPoint with one chart to a slide.,My question is
there a way to quickly export the...

Thanks to you all, and special Thanks to Steve.

dubdub

Any suggestion(s) for a nested right function with if(..) for these specific text(s) in a string.

TIA

Any suggestion(s) for a nested right function with if(..) for these specific text(s) in a string.

TIA

Assume i want to extract the exact text,"SE' or "wed" or "dawn", in the string and these text are at the end.

TIA

the string has variable length and the text is always at the end of the string.

TIA

hi all,

what would be the formula if you want to extract a variable length text located at the end of a string. for example the text can be "SE' or "wed" or "dawn".

TIA