Great Great Thanks Maudibe.
Type: Posts; User: dubdub; Keyword(s):
Great Great Thanks Maudibe.
My appology, the previous file is not the one,please consider this one
I need help to apply icon style format beside cell value based on the following conditions:
If cell value = 0 then no format
If =100 then green icon
If <100 then red icon
If >100 then...
Splendid solutions, right on the money Maudibe.
Great thanks to you Maudibe & Paul,
and i am sorry i did not provide enough information in my first post. i have a list with repetitive names in column "b" and i want to assign an order number to...
i need help with a formula that can output a data order number as shown below.
Many Thanks Eric,
wonderful, is there a way to include the headings under which the highlighted code exist, also is there a way to include multiple codes using this procedure.
I have a 100 page document. The paragraphs in the document ends with codes like “SAM”, “GAMD”, ”BD&WT” in brackets “()”. What I need is a code that enables me to do extract based on...
As always perfect. Great thanks Steve.
i have the data in column a and i want a formula that produce the results in column b. the equestion should enter "flower" and "sand" cat sequesnce if there a repatitive names in...
Greate Thanks Steve, and my sicere apolgy for very late reply.
Any suggestions, how to copy the style of bullets from one document to another one.
thanks a gain to all of you, and sorry for late reply. i will look into the code option.
Many Thanks to you Steve and to you Maud, but i was able to mange for now using SQL.
i have a sample of my data below. Basically, it consists of string of data in one column that i want to fragment into four columns. Note the third column in the output is the sum of the...
Thank you Steve, and my sincere apology for the late reply. i will give it a try.
i have the attached data sample (input) that i want to reformat (output) as depicted in the attachment.
this is exactly what i did.
when you click replace it add the new statement to the footer section of each page, how to prevent it from doing that.
i am looking for sites that enable adding interpolation/extrapolation functions like spline and others that does not exist under the list of xl function. any help/ideas.
it works but i am struggling with the appearance of the added statement with the footer line statement. i did exactly what you said after i added the statement underneath the...
it is time consuming to do it manually for each paragraph. i am looking for easy way to do it.
i have a large document and i want to add a statement at single apace below each paragraph in the document, something like
Update to reflect the latest:
the statement needs to be...
i have the down pivot data sample and i want to exclude the zero values
DELTA (x-y) DELTA (x-y) Total
fax 1999 2000 2001
akrm 0 0 0 0
adm 0 0 0 0