Put A Coloumn Next To Each Dialled

Nov 11, 2008

i used Sumif and Countif for a spreadsheet, but i need another column and need something like 'labelif' if it exists.

I have a phone bill with all calls made from our voip phones
Then i have a list of all of our mobile numbers
What i want to do is to put a coloumn next to each dialled call on our phone sheet saying 'us' or 'not us' if we dialled one of our own mobile numbers.
As the sheet has 11036 phone calls i really want a formula for it!!

View 9 Replies

Match Up & Clearly Highlight The Pairs (duplicates) In Each Coloumn

Dec 3, 2008

A:2007 Email Addresses
john@yahoo.com
Sam@hotmail.com
etc
etc
>6000 more email address9000 more email addresses)

I need to match up & clearly highlight the pairs (duplicates) in each coloumn.
What's the trick for this?

View 9 Replies View Related

Bold Text In One Coloumn If The The Data In Another Column Is Checked

Nov 12, 2009

How can I change the format ie. Bold Text in one coloumn if the the data in another column is checked.

Basically, want the text in corresponding row of column "B2:B124" to be bold if the check box in the perspective row is checked?

View 9 Replies View Related

Sumproduct Macro: Check One Coloumn For Negative Numbers And Another For A Date

Jun 30, 2009

I have a problem with a sumproduct formula which check one coloumn for negative numbers and another for a date so that it count all cases of negative numbers in a month i choose. (S contains numbers and AH contains dates)....

When i use it in a makro i get a "type mismatch" when i run the macro. I wonder if anyone can see where my syntaks is incorrect? Here is how it looks in the macro:.....

View 4 Replies View Related

Macro: Changing Color Of Coloumn Header Based On Rows Color

Jan 15, 2009

I wrote a macro to color the cell values in the rows based on their average value. For eg if the cell value is less than 0.2 Avg, they should be red color,if value is between 0.2 and 0.5 it should be yellow. This part is working fine

Now based on the color of the rows cells , need to write a macro for the header one. Logic is Coloum header should be in red colour, if in one or more number of rows cells are red. same with yellow ones. Could you please help me out in solving this with logic.

Put A Coloumn Next To Each Dialled

Match Up & Clearly Highlight The Pairs (duplicates) In Each Coloumn

Bold Text In One Coloumn If The The Data In Another Column Is Checked

Sumproduct Macro: Check One Coloumn For Negative Numbers And Another For A Date

Macro: Changing Color Of Coloumn Header Based On Rows Color

Text To Columns: Split Data In Seperate Seperate Coloumn