Search results

I can do that. But want some creative way of doing that by formula or anyother... the posted special characters are limited, however, the actucal data contains lot more... so I have to identify the all the special characters first and then apply find and replace which comsumes lot of time...

I have the following naming caonevtion with spcial and without special characters... Chintan Trivedi Chintan.Trivedi Chinta_Trivedi .Chintan Trivedi Against which the marks are posted. And I want the marks to be fecthed in different excel sheet. These are the same student and so has same...

Thanks you all. Manual Feed means "mannual input"

I have huge data in a sheet (almost 20 collumns and 245 raws) with and without formulas. I want to change the mannual feed cell font colour to Bule (or anything) from default (Black). Please let me know the shortest way of doing that.... Thanks.

Hi, but it not actually a watermark as whenever user click the cell on which it inserted it got selected. So is there any way to insert watermark or so. Or can we go into the programming of MS Excel and repalced the page ... with any other name?

Hi, Could we change the "Page 1, Page 2 an so on " to any other name concention i.e. India 1, India 2 and so on " written as watermark in excel sheet when page break view is on?

ohhhh... I could not think in this direction... thanks sir

Hi Faseeh, Great Sir!!! Thanks for the help. Just one query, that could we not cap the upper limit (10,000)

Hi, Thanks you for the promopt reply, In this case where the basic payment is not excactly the same as per ESIC scale, then vlookup() will not working. I would request you to guide me to formulate vlookup() for the range function. Thanks sir!!!

I have the following data of basic payment range (in column A) and ESIC decuctible in column B: A B 1 0-1000 50 2 1001-3000 100 3 3001-5000 150 4 >5000 300 Employee Basic ESIC Decuctible Raj 3000 Ramesh 5010 Raviraj...

Ok thanks Faseeh!!! Just wat to confirm that the writing convention for the sheet name( in the same file) and sheet name ( in other workbook) will remain the same?

Thanks for the reply. Just want to know that can we use external file name instaed of sheet name? And if yes, then what is the writing convention indicate the Excel that this is from linked to sheet of this one is from external file> sheet Name.

IF(ISERROR(+VLOOKUP($B2193,INDIRECT("'"& TEXT(E$10,"dd-mmm-yy")& "'"&"!$B$7:$Z$2500"),$A$3,0))," ",VLOOKUP($B2193,INDIRECT("'"& TEXT(E$10,"dd-mmm-yy")& "'"&"!$B$7:$Z$2500"),$A$3,0))

Hi, I am in serch of a formula that can directly derived the source formatting. Thanks for the reply.

Hi, you cab use the conditional formating for that. Select both the column > Home> conditinal formating > Highlight cells Rules> Duplicate Values There you find two drop down. In the first drop-down the default one is Duplicate you can change to Unique and apply it.

Can anyone hlep me out? I have some data in the column A and need to refer3nce it to column B by someformula with the destination formating. A1 B1 12 12 The value in the A1 is formated as Red Bold Font and want to carry the same formating with the value to B1.

I have to copy and paste almost 300 chart every week (on Thursday). I don't know the VBA Macro and aware that VBA could help me out in this work. I want to export all the graphs with particulart formating as follow: Graph Size: L: 3.6" Font size: 6 Graph Header Fornt Size: 8 Graph...

I have checke that bt the link is not there. Now I am checking the graphs (289) mannually for the external link. Thanks for the reply.

I have a workbook conaining more than 10 sheets and that are featched by formula. To reduce the file size I used " Move and copy" option for some of the sheets that are crustial for me. However, the newly created file shown that there is a external link in this file. I can simply brak the...