The discussions

“false” result not working on if formula

 Solved

Hello, This is the formula: =IF(Z2>=TIME(11|59|0)|"Afternoon"|"Morning") The contents in cell Z2 is 10:31:30. I was hoping my formula result w...

4 replies Last reply on 17 Jul 2009 by
aquarelle

I can't open my inbok

Hello,

1 reply Last reply on 17 Jul 2009 by
fobvious5

Help retrieve yahoo password

Hello, pls help my retrieve my yahoo password x gurl changed

1 reply Last reply on 17 Jul 2009 by
strnnger

Cost per page countif formulea

Hello, My hospital in South Georgia - US - chages .97 cents per medical record page from 1 -20 .83 cents per medical...

2 replies Last reply on 17 Jul 2009 by
Rob

Finding insertion point in excel

Hello here is a challenging one.... I am trying to automate a spreadsheet used for processing and compiling large amounts of data, with the outp...

1 reply Last reply on 17 Jul 2009 by
Excelguru

My yahoo id and password has been hacked by..

 Closed

Hello, My yahoo id and password has been hacked by someone. i need help to get back my account. i tried to verify my information but i wont able ...

Last reply on 17 Jul 2009 by
olfo81

Random seclection of data from a list in exl

Hello, I have three sheets 1) Data 2) Sample 3) Dummy In the data sheet in the first two colum the data is present colum A contains managers a...

1 reply Last reply on 17 Jul 2009 by
venkat1926

Excel

Hello, I'm using Excel and a barcode scanner program to update an equipment inventory. Currently I'm using the barcode scanner software to open a "f...

1 reply Last reply on 17 Jul 2009 by
Excelguru

Multiple sheets with data

Hi I have a spreadsheet with 8 clients listed on 8 rows. There are 9 coulmns of information. I have the following formula at the very bottom of the sh...

1 reply Last reply on 17 Jul 2009 by
Excelguru

Copy numbers of cell values in a single row

Hello, I have unit numbers in multiple rows which is captured from a pivot table from another sheet. I need to consolidate all the cell values fro...

1 reply Last reply on 17 Jul 2009 by
Excelguru

Copy data from many worksheets to a compiled

Hello, I want to write a macro for some data in excel. I have multiple worksheets that I need to copy a column of data from each and paste them into...

1 reply Last reply on 17 Jul 2009 by
Excelguru

How to compare data between two tables

Hello, I have two tables (table A and table B) and I need to compare the two tables to see if a specific userid exist in both tables. If the id ex...

2 replies Last reply on 16 Jul 2009 by
Excelguru

New sheet using conditional formatting

Hello, I have a very basic table on Excel which I use to keep contract data. I'm currently using conditional formatting to highlight the row if th...

5 replies Last reply on 16 Jul 2009 by
venkat1926

Userform for importing sheet from one excel

Hello, I want to create a user form in MS excel that will prompt the user for the file name. Once the user browses the file name it should copy th...

1 reply Last reply on 16 Jul 2009 by
epsiman

Vba: error 9; subscript is out of reach

 Solved

Hello, Depending on the value of a specific cell (sheet "gegevensblad" cell L10), I would like to hide 1 out of 2 sheets (Either Overzichtsgrafieke...

4 replies Last reply on 16 Jul 2009 by
Dean

Plese send via power point

Hello, Dear sir i want to format my hard disk via pen drive instead of XP bootable Cd.in short i want to make my pen drive as bootable XP disc.s...

1 reply Last reply on 16 Jul 2009 by
onea97

Send information via power point

Hello, sir send answer plese

1 reply Last reply on 16 Jul 2009 by
onea97

Copying data into different cells using macro

Hello, I am trying to use macros to copy data from one cell into different cells in another sheet. My data is consisting of Organisation contact deta...

1 reply Last reply on 16 Jul 2009 by
raju

Compare and update excel sheet

Hello, I have got two excel sheets one master sheet that gets updated everymonth with the new employees joining that month. the other excel sheet nee...

2 replies Last reply on 16 Jul 2009 by
ujo

Gmail password

Hello, My name is Rochelle I I forgot my password to check emails, could someone please reset it, or can this be done over the phone I need it like y...

1 reply Last reply on 16 Jul 2009 by
afsgun

Vba help needed

Hello, im having an issue, what im whant to achive is this. i want to be able to select ranges depending on the content of the cells in column A, a...

1 reply Last reply on 15 Jul 2009 by
venkat1926

Visual basic code for finding a string in mic

Hello, i just want to know a function or a code to find a string in Microsoft excel macros.

1 reply Last reply on 15 Jul 2009 by
venkat1926

Macro excel 2007 help

Hello, hey guys i need help in excel.... assignment in my row F I have 2 data Permanent and contract. So i want to make it that when I type it in sh...

7 replies Last reply on 15 Jul 2009 by
venkat1926

My password was solen

Hello, my name is bilal and somebody stole my hotmail , and really I can't remember my secret answer , so please tell me how I can reset my password...

1 reply Last reply on 15 Jul 2009 by
closeup22

How to browse on my pc throug my phone

Hello, I want to connect my phone which is connected to the internet to my computer which is not connected to the internet so that I can browse on my...

1 reply Last reply on 15 Jul 2009 by
closeup22

I forgot my password & question

Hello, I forgot my passwor & the question also, Pls help me out.

1 reply Last reply on 15 Jul 2009 by
flcconflict

Colouring a cell automatically

Hello Guys, I don have much knowledge abt Excel and abt the codes n stuff.... But i have a question to ask u guys... The question is this: Th...

3 replies Last reply on 15 Jul 2009 by
Bang.......

Vba code in a excel form

Hi, I made an Excel form for colleagues to enter data in a sheet in rows. I made a second form on wich other colleagues need to find a 6 digit nu...

1 reply Last reply on 15 Jul 2009 by
VBAhelp_Needed

Look up a cell in column and add another

Hello, I'm trying to look up an item in one column and see how many were sold from another column. The columns are side by side. There are 5 items ...

1 reply Last reply on 15 Jul 2009 by
mubashir aziz

If= change the colour of the line ?

Hello, I'm having a bit of trouble, what i need is if a box says yes the whole line that its on goes red and if it says no then the line goes...

1 reply Last reply on 15 Jul 2009 by
mubashir aziz

Outlook email

Hello, I have recently installed teh latest Office suite, including Outlook, onto a new pc. I run a personal business address from my Outlook which h...

1 reply Last reply on 14 Jul 2009 by
Silverbird

Version

Hello,i wan to ask which version of Nero can make a bootable CD i have nero 6.it is urjant

1 reply Last reply on 14 Jul 2009 by
suff954

I lost my gmail password

Hello, plz help me i lostmy gmail password my gmail id is 007shaileshz@gmail.com plz ineed this

1 reply Last reply on 14 Jul 2009 by
Anan Das

Old emails

Hello, I had an order from L. L. Bean that gave a tracking # so that I could see where my order was. I went to the website and you have to have the t...

1 reply Last reply on 14 Jul 2009 by
Mariah

Asking motherboard password

Hello, some virus attacke to my system , if i insert anti virus cd its asking motherboard passward. we do know the password because i purchased long ...

1 reply Last reply on 14 Jul 2009 by
strnnger

I am forget my password gmailid

Hello, sir my name is nikhil i am forget my password please help me i acan not open my id so what u do

3 replies Last reply on 14 Jul 2009 by
Anelly

Loop for copying/ pasting data (batch process

Hello, I have a worksheet that has 3 tabs. The first tab stores all the personal employee data I need to run pension calculations for Employees. ...

1 reply Last reply on 13 Jul 2009 by
Excelguru

List month from any given year in excel

 Solved

Hello, i 0got a spreadsheet (data) as below date status 1-jan-1975 approved 1-feb-1980 suspended 5-mar-1985 rejected 10...

6 replies Last reply on 13 Jul 2009 by
ani

Password recovery

Hello, i have acer lcd monitor and i m the main user of my computer but i have lost my password and i can not login now. please reply with a solution

1 reply Last reply on 13 Jul 2009 by
aman

How to deal cells with same content except on

Hello, hey i got lots of data in the B collum a lot of the data is the same, repeated in row after row but not all data is the same. waht i have trie...

1 reply Last reply on 13 Jul 2009 by
Trowa

Repeating formula in a specific number of row

Hello, I'm trying to develop a formula that will repeat a result in a specific number of rows. For example, if there was a number "2" in A2 and a "...

1 reply Last reply on 13 Jul 2009 by
Trowa

Password changed

Hello, please tell me how to delete my e mail id..someone changed my password and misusing it..

1 reply Last reply on 13 Jul 2009 by
jak58

How to move the activecell to the next row

Hello, Move the ActiveCell to the next row is simple: ActiveCell.Offset(1,0).Select Ok. But if AutoFilter is on, that command can lead me to a non ...

1 reply Last reply on 12 Jul 2009 by
venkat1926

How to create a macro

Hello, i am completely new to the task of creating macros.can you please tell me how should i create a macro so that all the cells under a particul...

1 reply Last reply on 12 Jul 2009 by
venkat1926

Making sheet increasing#'s&but same letters

Hello, labels that must have same V33j on all as well as another group of numbers usually 3 or 4more that would increase or advance by 1 number as ea...

1 reply Last reply on 12 Jul 2009 by
Excelguru

Any

Hello,

1 reply Last reply on 12 Jul 2009 by
olfo81

Sales tax formula for exel 2007

Hello, How do you write a formula for sales tax in an Excel 2007 document? Please help!!! Sam

1 reply Last reply on 11 Jul 2009 by
Excelguru

Look up new numbers from old list in new list

Hello, i am trying to look up new number in one list in a new list to see if there was new data added w/ the new list. I would like for the new numbe...

4 replies Last reply on 11 Jul 2009 by
Excelguru

How to add a ready macro to excel

Hello, I have downloaded a macro from a blog to keep a track of time and date when a cell was modified last. Please help me how to add it to the exc...

1 reply Last reply on 11 Jul 2009 by
venkat1926

Percentage formula

Hello, i wanted to create a formula in excel, how do i create a percentage formula in excel (215 x 4 % equals what)

1 reply Last reply on 11 Jul 2009 by
venkat1926
Results 11351 - 11400 out of a total of 12,269