# Forum

Search
Close
Results 101 - 134 of about 134
• ## Conditional Formatting (more than 3) in Excel

It can be easily done on MS Excel 2007. My macro skill is not good enough but i'll try to check it out ...... -- ...

• ## Excel: Convert Oz. to milliliters inside Text

I"m sending solution of your answer but with some restriction as I worked on it hard but couldn't still sort it out completely .... anyway you can...

• ## naming range in a macro

Suppose your data is in Range A3 to onward so using this formula in =OFFSET(Sheet1!\$A\$3,0,0,COUNT(Sheet2!\$A:\$A),1) or you can use countA...

• ## index and matching 2 different spreadsheets

Now write below formula in Sheet1 column location which suppose in A2 You are writing this formula in blank cell of sheet1 ...

• ## How to count multiple instances in single cel

Your explanations are not enough for me but as per my understanding ....... Suppose you have data in Column A from A2 to A50 then in any cell...

• ## use result of one cell to affect another

Try this formula in Cell C2 ................. =IF(L52>=0,AVERAGE(D52:K52),"") -- Never ashamed to get or give Advise. Muhammad...

• ## Cell Date Creates a New Sheet

The best thing is use of Vlook up .....For this purpose in your data seet you have to all nececssary inputs like Date, Amount and now enter...

• ## Excel Formulas [Solved]

Write this formula in Cell B , C and any one else but not in Column A ..... Column A contains the values A 1 2 3 4 6 and in Column B...

• ## If Than

I can't understand what you are trying to say.......... Any way try to use this below formula ..... first {bracket} will check the value and...

• ## Macro iterate through with If

Try below code .... Actually i'm unable to use Name funcation in VBA else it will run automatically upto the rows count in E. I defined a name...

• ## Reagerding Macro

Start Excel and go in Tools > Option > Security > Macro Security > Security Level > Low (Click on Low) OK .... Now Close & Run Excel again...

• ## Excel Formatting and sorting dates

Its working fine. u must enter date format as ddmmyyyy AND when you will enter 5-8-09 it will automatically convert it as 05082009. check date...

• ## Need to do vlookup and return differen values

Suppose your data is in Sheet from Cell A2 to C8 ..... Now in Sheet2 in Cell A1 write a name which is in sheet1 and now in Sheet 2 write below...

• ## Find text, get number and color cell green

Now in Months sheet you have to use conditional formatting comparing it with your calculation sheet. but for this you have to given your ranges a...

• ## How to calculate positions(1st,2nd,3rd...) in Excel [Solved/Closed]

Suppose your data is in column b from 2 to 9 then in C2 you can post this formula and drag down .... =RANK(B2,\$B\$2:\$B\$9)

• ## Linking cells within Excel

Suppose you have Cell A2 in Sheet1 now go in Sheet2 , Cell A2 just put =Sheet1!A2 When ever you will change in value in A2 cell of sheet1 your A2...

• ## countifs function

Can you email me your sheet on my email maziz@jgc-descon.com.pk

• ## execel hint

Try to use vlookup ...................

• ## auto copying from sheet to other sheet text a

Its confusing as you are talking about 4 sheets then wanna copy the data from one sheet to other sheet???? Do you want copy data from Sheet1 to...

• ## counting cell with specific time

Change the cell format of the cell where you have entered the formula !!!!! make it number

• ## Run macro automatically [Solved]

Try to run the macro as below copy your code here and you can select it from VBA windows by selecting desired Sheet then on right side window...

• ## formula

You can use vlookup to get in combo box or in datavalidation box .......

• ## checking multiple Cell values and validating

This can do done with conditional formatting but i don't know exactly which type of value you wanna highlight ????? is the duplicate or any value...

• ## conditional formatting

Its simple but will you clarify that you have incorrect data in column G marked as Red .... did you extract data from some other columns ???? ...

• ## worksheet name

Try it ..... https://www.ozgrid.com/Excel/variable-worksheet-names.htm

• ## stock sheet

It is necessary to see your file as i don't know how exactly you are doing work. As per my understanding you have two sheet. 1. Stock Available...

• ## How do I Copy Two Cell Ranges to New Blank 2

Below macro will copy First 3 column of Sheet1 in Sheet 2 .... you can change selection as per your requirements ..... Sub copy_three_col() ...

• ## Excel cell flash when date is near

Suppose you have data in Cell A1 to onward now select whole area from A1 to onward. Now Put Conditional Formatting Format > Conditional Format >...

• ## Excel - reset / replace seconds to zero [Solved]

Suppose you have data in Sheet1!CellA1:A36. Now in Sheet two Column A write 0:00:00 to 23:59:00 values ....... now in sheet2!B1 write this formula...

• ## Extract identical cells of 2 columns (excel)

Write it in Column C1 and drag it uptill end .... =IF(A1=B1,A1,"")

• ## Excel

Do you want to mean Entries or just selection ?????? You can select cell by click on it ....... About Entries 1. Press F2 2. Double...

• ## Images don't print when printing selected pag [Solved]

Check the print area of selected pages !!!!!!!!

• ## MULTIPLE SEARCH \$ MULTIPLE RETRIEVAL IN EXCEL

Your question is confusing .... "I want to search for the value in column1 and give its corresponding value in MS-EXCEL" what you mean by...

• ## Prefix 0 to all records in a column [Solved/Closed]

If the data in numeric then select the columns and go in Format > Cell > Number > Custom > write 0 #,##.00 your all number will have 0...

Recommended

DON'T MISS

TRENDING GAMES & APPS
• Professional

• Internet

• Internet

• Professional

• Internet

• Internet

• Video games

• Internet

• Video games

• Professional

• Video games