# Forum

Search
Close
Results 1 - 50 of about 134
• ## Excel If Function over a range of dates [Solved]

Suppose your values are in Cell A2 then put this formula in Cell B2 and drag it down ...

• ## Find word within cell & put value in adjacent [Solved/Closed]

Sorry I couldn't get you ....... please be more specific like Column A1:A12 THE OCEAN IS BLACK I LIKE HIS BLUE SHIRT BLUE IS MY FAVE...

• ## Change cell reference mutliple sheets formula

Just select the cell and then go to Format>Cell>Number>Fraction and on left side window select desired format ..... -- ...

• ## IF Advance Function [Solved]

u welcome -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

. -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## remove blank cell from conditional formatting

. -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## Find max for selected number of values

. -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## Comparing columns and returning value [Solved/Closed]

Suppose you are compaing Col. B with Col A. now write this formula in C1 and drag it down ... hope it will help you ...... ...

• ## pickup value in excel cell

Eli you always welcome .... cheers -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## compare column

Sorry i couldn't understand what you want ???? column 1 column 2 red blue blue red I would like to consolidate the data into column 1 so...

• ## Look up a cell in column and add another

YOU CAN SIMPLE USE =SUMIF(A3:A7,D3,"Frid",B7) -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## IF= CHANGE THE COLOUR OF THE LINE ?

This is because of using Conditional Formatting. you can just explore it thru excel help ...... suppose your data in A1 then in Conditional...

• ## Partial Cell Match of Company Names in Excel [Solved/Closed]

Hi, If your value is in column A & B starting from Row 2 then try this formula by writing in B2 =MATCH("*"&LEFT(A2,5)&"*",B2:B29,0) now drag...

• ## Look at column and match and add this text te [Solved/Closed]

Hi James, Try to use ranges instead of A:A mean =INDEX(Sheet1!\$B\$1:\$B\$100,(MATCH(Sheet2!A2,Sheet1!\$A\$1:\$A\$100,0))) -- ...

• ## if cell blank copy next cell

Hello, I have a list in a certain column that contains blanks and I would like to consolidate that list to not include the blanks in another...

• ## Excel will not open

Tell me are you facing this problem from the very first day ??? if yes then during installation of office you didn't install the Excel properly or...

• ## Comparing to Colums

If you are just want to show up the name which are in column A but not in column C then below formula will work for you and will show you the name...

• ## running total

May be that can be achieved thru a macro but I am not expert in macro and someone else can give a better solution ..... -- Never ashamed to...

• ## Excel "IF" formula problem [Solved]

Here I used N() to convert the text into value "0". Below example will explain remain usage of N() A2=7 A3=Hello A4=TRUE A5=4/17/2008 ...

• ## Excel unique filters

You can try advanced filter on one column then easily extract these unique records to separate place ....... then you can apply on other column...

• ## Find a string in Excel and remove all cells [Solved]

you can select all columns in work sheet then press Ctrl+H to replace and then in Find What bar write abc and in replace with bar write nothing...

• ## IF fnct

yes sure you can see below solution from mine ..... you can use upto 36 IF's and 37 conditions .... you can paste this code in B3 and in A3...

• ## Compare and match

if you have the same arrangement of columns in work books and also in sheet1 then use below formula workbook1:sheet1 ...

• ## EXTRACT A LIST FROM 2 COLUMNS

Suppose data started from row A2:B50 then in C2 write this formula C2=IF(ISERROR(MATCH(A2,\$B\$2:\$B\$50,0)),"",A2) and drag it down ...... ...

• ## Filter unique records using some value

You can easily done by using Data > Advanced Filter > here you can see option Copy to other location just check it and also check in Unique...

• ## rang selection

I am not an expert in Macro but can give you suggestion by using work sheet function, if you like ..... Suppose you have data in A1 now in B1...

• ## Excel Form Frustration

This type of data can be easily sorted out thru Pivot table but you will have to arrange data in an organized way ....... I"m suggesting some...

• ## Use Vlookup to match data in two seperate she

Suppose you have two sheets Sheet 1 and Sheet 2 now you want to hight light the cells in sheet 1 which are not in sheet 2 ........... 1....

• ## EXCEL - COUNT 2 DIF. VALUES IN 2 DIF. RANGES

Your formula will work well in MS Excel 2007 as it can work with C:C whole column =SUMPRODUCT((C:C, "O5")*(E:E, "CC0")) But in 2003 or below...

• ## moving data from rows into columns for every [Solved]

I think my formula just giving you the result as you are getting from macro !!!! Sorry i'm completely stumped. Can you give me some example if you...

• ## Counting number of times a value appears if.. [Solved]

Suppose your data is in Column A then paste this formula anywhere or in A12 and Press Ctr+Shift+Enter as this is any Array formula ....... After...

• ## Can this work

Really unable to under stand what you want ?????? be more specific what you actually want and tell me in details what result you want ....... i...

• ## excel formula

use Rank() function to get the result .... suppose your data is in Column A from A2 to a6 then in B2 write this formula and drag it down ... ...

• ## Excel Formular Problem [Solved]

=IF(B2=1,"Entertainment","")IF{C2=1,"Sport","") Are you clear about your code ???? Do you want to check B2 & C2 one by one ???? then...

• ## Search data in one column, copy data in new

Sorry don't have enough macro knowledge ...... -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## use of zero with multiple number

Actually it depends on your needs suppose you have 5 digit employees number so you want that if you enter 1 then it should be 0001 and if 555 then...

• ## is it possible to post the sheet in your foru

This is the big problem in this forum that members can't upload excel file or image ...... imageshack and many many hosting sites are blocked in...

• ## Reference table

Sure you can share .... or PM me .... -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## Can't print my timesheets

Have you checked your print area ????? -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## using nested if to blank out adjacent cells

The best way to do this type of work is use of Option Buttons from Froms Tool Barr ... you can delete their name from the box and can group them...

• ## find last column in table

Sorry not an expert in macro .... -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## Urgent in excel

Very confusing explanation ????? Really unable to understand what you exactly want. I"m just creating heading which will be helpful for you or at...

• ## Copying rows into a different sheet.

I'm doubtful about inserting a row in one sheet and auto updation in other sheet. I think it can be thru macro but i'm not master in macros ........

• ## Comparing two excel worksheets [Solved/Closed]

Look below example ...try it and if there is some problem then do let me know .... http://ccm.net/forum/affich 104112 look at column and...

• ## Matching two worksheets

See if it helped ???? http://ccm.net/forum/affich 104112 look at column and match and add this text te?#2 -- Never ashamed to...

• ## match names&dates

Just write this formula in E2 and drag it down ... .then using filter you can selected "delete" from the column E and delete the row .... ...

• ## Need Macro to sort thru raw data

In this case Pivot Tables are the best thing to do ..... you can get info about Pivot from the net .... -- Never ashamed to get or give...

• ## Need Help in Excel

Suppose you have data in Column A in Sheet 1 & Sheet 2 then use this formula in Sheet3 Cell A1 and drag it down .... ........ ...

• ## Excel Total Range of Values [Solved]

u alwaz welcome .... -- Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan

• ## excel

Where is the problem ??????? you are giving solution your self ........ implement this to all your sheet ..... -- Never ashamed to get or...

Recommended

DON'T MISS

• Internet

• Video games

• Video

• Video

• Internet

### Instagram for PC

• Office software

• Security

• Internet