The discussions
Excel if formula help requesr
Hello, i am entering my formula like " =IF(H5=AMC,"=M5*5%") " but i am gating error like #NAME, can any body help me to calculate 5% value of my M5 a...
Email/password
Hello,i need to know my password that combine with my Email
Hidden files or installed
Hello, yes the file is there and the details but when i open it , there's no content or cannot display the file
Only run a option button macro if a cell >0
Can anyone help with adding a limitation to a macro? I currently have a very simple option button activating another worksheet in the workbook. But I...
Compare two columns and delete duplicates
SolvedI have a large amount of data that is supposed to be unique based on two columns (Column A, Column B). The combination of these two columns are not s...
Link pivot to mail
Hello, Anybody know I can auto link a Pivot Table from My Excel sheet into a email??
Automate simultaneous entry of data in cells
Hello, I need to format two Excel cells on the same sheet so that when data is entered into one, the same data automatically is entered or copied in...
Excel cell reference; '=+' meaning
Hello friends here, I wish to ask a question about Excel cell referencing cell value from another work sheet. 1. The value in the cell was like ...
Excell formula
Hello, I want to add an alphabatic letter in percentage formula in excell sheet. plz write me how can i do it.
How to seperate values in the same colomn
Hello Can some 1 help me please im trying to set up a spread sheet, i have different information in one column, i just want to seprate it for e.g A1...
Compare
Hello, I am trying to compare the value of a cell. To see if it is greater than one value and less than another. If true then add 1 to a variable. ...
Excel formulae - value of row above
Hello, I have to rows of values as shown below 1 G F E D C B A A* 2 1 5 8 25 9 10 15 12 3 4 ...
Compare 3 columns excel
SolvedHello, I have to compare 3 columns (A,B AND C) filled with names and return, in another column (E), the list adding the names from the 3 columns (...
Urgent condition formatting more than 3
Hello, How can you change the colour of a drop down list names as well as the cells under it, that is if the drop down list are all my salespeople's ...
Help need writing a formula please
SolvedHello, I have a report I pull which outputs IDs. There are 5 IDs. Management would like to display their respective Site locations instead of the IDs...
Accidently deleted law school essay
Hello, I have just deleted part of a test I was taking doing a personal statement for Law School. I immediately tried the undo function, but it wou...
I want to browse 4 free
Hello, pls tell me hw i can browse with my nokia 5130 c free of charge,tru opera 4.5
If(b1>b2, b1*b2) will return
Hello, Plz give me the answer of my title question.plz
Conditional search for text substrings
Hello, This is one of several nested conditional statements that if I can get to work as required I can modify the remaining statements: =IF((VL...
Mircosoft excel formatting cells complicated
Hello, i need to change the color of certain cells based on percentage. for example if i have 20 trucks but 6 break down then i have 14 remaining. So...
How can copy whole data from excel 07 sheets
Hello, I am using MS Office 2007. Please let me know that how can I copy whole data from sheet one to sheet two. I want to copy the whole data f...
Problame in ms office
Hello, actually i download the ms office after that i want to activate software online but it didnt happens
Pasting formulas in excel
Hello, Quick question guys, when i insert a formula in a cell in excell i normally get a little cursor appearing on the smae box on the bottom righ...
Merging data from 7 worksheets into 1 pivot
Hey, I have seven worksheets within on of my excel spreadsheets. Within each worksheet i have several columns and i am seeking to summarise the dat...
Excel macro to group by column & sum value
SolvedHi there, I need to write a macro for following example. Item Qty Length A 1 100 A 1 100 B 2 200 B 1 100 B 5 100 C 4 200 C 2 100 C...
Change date format
Hello, I typed like this - 18/05/1985, Now I need to change like 18-May-1985. I changed Date format but it is not change and this kind of format. gi...
Result in column d
Hello, A1 B1 C1 D1 Code Client Rept Results 3610183419 Gilles Brunet 5 Gilles Brunet, Gilles Brunet, Gilles Brunet, Gilles Brunet, Gilles Brunet ...
Excel conditional formating! help need!
Hello,every one! I have massive problem on off my reports which I need to do for work includes conditional formatting or some specific formula and ...
Help with excel formula
Hello, I have a question but can not explain. Basically I want to find first row Value from range MIN(A1:A10000) that satisfy some condition.I need ...
Vista admin password
Hello, I have a Toshiba satellite laptop and had to recover it. The problem I am facing now is:a) I am not able to log on as admin since there is no ...
Options menu is missing in tools in msword
Hello, options menu is missing in tools in msword can you give some idea for resolving it
Monthy financials expressedas average per day
Hello, I have a workbook with a worksheet for each day of the month. A summary sheet shows totals per date (1st, 2nd, 3rd, &tc.). I want to c...
Forgot the password
Hello, i have 1 GB micro SD memory card whose password is locked please suggest me the software which will format my memory card
Need to run 3 loop in a single sheet macro
Hello, I can able to run my requirment by 2 macro, i need to run in a single macro. How to calculate this in single macro? Ex. A1 ...
Adding cells
SolvedHello, I am trying to build a macro that allows me to input a number on Sheet1 and then on Sheet2, add that number of Cells. Example. Sheet1 ...
Compare cell with column
Hello, Hi i want a formula to compare for example IS136677 with the similar vaue from the right hand side which is shuffled eg. IS141158098.25 is a...
Macro to extract to a new column
Hello, I need help with a excel formula, as follows HP LASERJET 4250/4350 HI TONER CARTRIDGE HP #78 TRI COLOUR INK CARTRIDGE (19ml) HP #98...
Conditional formating on formala cells
Hello, i m trying to apply the conditional formating on the cell which is containg the formula, a b c ...
Help with excel percentages
SolvedHello, Please bear with me as I a very new to this type of syntax with that said here we go. I have four date columns in Excel like so: P...
Excel if help
Hello, I am having trouble with my excel spreadsheet. I want to do an if function but I also want the formula to do a calculation at the same time. F...
Long if statement in excel 2007, won't paste
Hello, I am trying to use data validation in excel 2007...below is the formula I am using to refer to data on a seperate worksheet. I know the formul...
Excel help
Hello, Please help me with this I want to limit my data entery in one cell. for example the data enterd in cell A2 should be less than or equal to...
If index #1 is
Hello, Is there a way to populate a cell with a value, provided two user-generated conditions are met? The user chooses condition 1 and conditio...
Convert active excel wksht to pdf file
SolvedHello, I'm trying to figure out how to create a macro to save an range selected in an active worksheet and save to a pdf file by clicking an inserted...
Master of free browsing has come.
Hello, i knw most Nigerians need a free working cheats 2 help browse lik fire. here, i come 2 make ur dreamz come. i work on all d Networks in Naija....
Log
Hello, How we can find the Audit log on send mails in gmail. Rgds, kavitha
Figuring a number based on a percentage incre
SolvedHello, if i have a number and want a formula to know that it is a percentage of another number, what is the formula in EXCEL? i.e. if i have a s...
Change of installment number
Hello, If, I took a loan of Rs. 36000 and repay by 36 monthly installment, for the month of April, installemtn number 1/36, how can change in wxcel ...
Excel formula
Hello, I need to create a formula that will compare which cell is greater than the other and then put the greater one into the cell. Say B4 compared ...
