How to Divide a Number With “Less Than” Sign?

March 4, 2009 by vba excel · 2 Comments
Filed under: Excel Tips 

Excel Tips Question:

Please help me to do a calculation from number of conversions from ug –> mg in a column. Many of the numbers that I need to convert have a “less than” sign… ie <1 should conv..... Read The Solution..

How To Transpose Column into Rows

March 4, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips 

Excel Tips Question:

I need your help to solve my excel problem, i have about 1600 contact name along with company name, address1, address2, city, state, and pincode

For Ex:
Mr.hardeep Kanwar
Bi/200
Ya..... Read The Solution..

Copy Vlookup Formula Between Cell

March 4, 2009 by vba excel · Leave a Comment
Filed under: Excel Tips 

Excel Tips Question:

Ive a problem When i try to copy a vlookup formula from between cell , its failed to copy the way it should be. The source is getting changed for every
next cell. Although i have selected “COPY..... Read The Solution..

Referencing Cell in Another Worksheet Within the Same Workbook

March 4, 2009 by vba excel · 1 Comment
Filed under: Excel Tips 

Excel Tips Question:

I have a workbook consists of contact names, numbers, and a combination of contact names and numbers. I have a landscape version and a portrait version. I want to only update one and the other automaticall..... Read The Solution..

« Previous Page