The discussions
Vlookup
SolvedHello guys, I wonder if you could advise: when I set my regular vlookup. And have found the requested result. How do I get excel to keep searching...
Separating items from columns
SolvedHello guys, Could you please help with this... Is it possible to do the following in excel: I have similar cells to this in one column: Ford v-36...
Sum # in column only if cell contain text
SolvedHello, e.g. I am trying to sum up the row of number when a cell in the same row contains text "Ball" [Column A] Red Ball Blue Ball C...
A macro to move data from rows to columns
SolvedHello, I have data in a single column and would like to copy it into a rows for every x rows, for example; The column of data varies in the amoun...
Spell number
SolvedHello, I would like to convert a number into words using rupees and cents in excel 2007. Please help. Configuration: Windows XP / Internet E...
How to match 2 row of data in excel ?
SolvedHello, brothers & sisters I have 2 columns of companies name say (column a=38900),(column b=1000) so how can i use a formula to do a match by thei...
Formulas
SolvedHello, Can you help please how do you do a formula Annual Gross profit ?? Thank you very much Configuration: Windows 7 / Firefox 15.0.1
Event causing a popup comment to be saved
SolvedHello, I am trying to create an even within multiple cells that would ask for a comment if certain conditions are met. For instance: If c...
Word 2010 why my clip art suddenly vanished
SolvedHello, is there anyone who can tell me why my clip art suddenly vanished from word..... It was there one day but gone the next & nothing I do seems to...
Text if/then formula to use seperate formulas
SolvedHello, I am trying to make a formula to determine how many days (minus weekends) it took to complet a project. The problem is that I have one empl...
Excel, comparing two sets of two rows
SolvedHello, I know the title may be a little confusing, and I apologize for that, but I really did not know how to phrase it. What I have is two Excel...
Need help to remove false from cell
SolvedHello, Anyone please. How remove FALSE from a cell Here below is my formula. =IF(ISNUMBER(G17);IF((G17-$I$10)
Remove false from cell
SolvedHello, how can I remove FALSE from the cell? I need help, any one please. her below is my formulat =IF(ISNUMBER(G17);IF((G17-$I$10)
Conditional formatting and if statements
SolvedHi Please can someone help with a problem I have encountered on Excel 2003. I am trying to use conditional formatting however I have 4 variables ra...
Macro to compare two excel sheets
Solved/ClosedHello, I need help to write macro to compare two sheets, sheet1 and sheet2 on same excel book and display the result on the third sheet. The ...
Excel help
SolvedHello, I have a schedule for the employees, and it contains seven columns as 7 days in a week. If any range of the columns contains text " ...
Excel: comparing two columns and output data
SolvedHello, I'm using Excel 2007 and am trying to figure out a way to analyze and sort some data. I have two sets of data in 6 and 5 columns in the sa...
Insert new data line when criteria met
SolvedGood day, I need to insert a new line with data when the criteria met based on the table below. Time Operation ------ ...
Problem with excel
SolvedHello, I was trying to write a formula in excel where IF A1 is greater than 7 then 1 would be substracted from it and if it is greater than 5 but...
Add/subtract & vlookup formula
SolvedHello, I need your help in solving the error re vlookup in my excel worksheet. Please find below the link to view the file. https://docs.google....
Set serial number base on date and starting
SolvedHello, I have a local purchase order (LPO) sheet in excel for two different group. I use LPO serial as SWM/SB/12/07/125 Swm/SB is permanent te...
Remove #div/0!
SolvedHello, I have below formula in a database and when "F" column is 0 it shows above. is there any ways that i can set this formula without appearing...
Reading pane
SolvedHello, I am wondering if there is a way to enlarge the font size ONLY in the reading pane above the spreadsheet, without actually changing the...
Editing different fonts
SolvedHello, Can you please tell me how i can edit the font size and parameters like bold,italics of (only) one fonts. To be clear, i want the parameters ...
Excel: splitting of data based on calculation
SolvedGood day, I would like to seek help to how to split and populate data based on the result of certain calculation. Here are the criteria for the...
Excel 2007 if function
SolvedHello, Need formula to say if cell has NA put 0 but if the cell has a date (yy,mm,dd) then subtract cell L1 from cell E1. Trying to determine how ...
Vba - transferring select data to new sheet
SolvedHey there, I'm trying to create a macro for an Excel 2003 spreadsheet that will take a record (a row (or rows)) that I've already selected into a new ...
I forgot apple i pod password
SolvedHELLO, i forgot my apple 8gb passeord bearning the model nos.A1285 and serial nos. 5U9203UK3QS Configuration: Windows XP / Internet Explorer 6.0
Vba code to conditionally copy the data
SolvedHello, need help! see I need a vba code that can copy data from sheet1(raw data) to sheet 2,sheet3 and so on is certain condition matches..exam...
Date -time subtraction..
SolvedHello, hi again,need help i need a macro that will subtract date-time in column A with the Present Date-time and display the value as number of da...
How to get sub strings using delimiter
Solvedhi, i want to copy the part of the string in a particular cell to another sheet. e.g. the string is cell A1 is as below: EVENT_ID NUMBER(10) ...
Highlighted cell on duplicate by multiple cln
SolvedHello, Configuration: Windows 7, MS Office 2007 Kindly help me i stuck in a problem, I have an Excel Sheet which contains Sales Figure an ...
Replacing cell values
SolvedHi, My requirement is to replace the cell values only for a given range. And my range is only the cell values in a given single column. Below is t...
Lost security lock password
SolvedHello, I have a nokia xpress music 5130-C. I set my security lock password as 55555. But now it is not taking the password. I tried the defau...
Vba macro help
SolvedHello, I have a report that I am using for a customer of mine that lists there kits in a matrix for me. Once in a while I find an error where a kit...
Conditional formatting using dates
SolvedHello, I have a training spreadsheet which I enter the date someone has undergone training. I want a red, amber, green system to alert me when traini...
Password remove
SolvedHello, memory card password recovery software from nokia c2-00 Configuration: Windows XP / Safari 535.19
Split mutiple columns in sets of 40
SolvedHello, I have data in 3 columns A,B,C and it goes to 1000 rows, I want it to be splitted in sets of 40 each . Like first 40 then next 40 and so on...
Copying from multiple wb in 1 folder to 1 wb
SolvedHello, You guys have been a great help for all my naive questions, so I have another for you. When it comes to architecting the layout of the cod...
Excle formula
SolvedHello, Dear People, I have a small Requirement in Excel. Can you please help me out? Problem Description: Content of Raw Material Prices are...
Forget password...?
SolvedHello, i use floder protect 1.9.2 unfortunately i forget my password so how can i know my password please help me.... Configuration: Windows XP...
Forgotten password for my acer 5315
SolvedHello I have an acer aspire 5315 and broke my charger, I have only just got it back on now and completely forgotten my password. I have treasured pics...
Dell im10-3354dd5 passwords don't work
SolvedHello, Dell inspiron iM10-3354DD5 ,service tag 9FK9QK1,need bios and HDd password . I hv all info on comp, receipt everything I wrote down passwor...
Retrive value to empty cell
SolvedHello, Hope you can help me... The user select a value from a list (in Column B), then Excel need to find this value from a column (Column D) o...
Pdf file convewrsion
SolvedI am having a similar problem to the one I have copied into the e mail below. It seems all of my adobe acrobat files have been converted word documen...
How to concanate two cells "line by line"
SolvedHello, I have one cell that has names separated with alt + enter. On the other cell, I have additional information on those names (also separate...
Text to n rows + copy row and insert n times
SolvedHello, I would appreciate your help with a macro I am trying to create in Excel 2007. My data is as follows: Column1 Column2 Column3 Column4 D...
Excel macro - set and autofill a range?
SolvedHello, I recorded a macro for excel and part of the code is to create an index column that fills the cell with a row count (i.e. A2=1, A3=2, etc.)...
Cherry mobile q3tv phonelock lost password
SolvedHow Can I Recover my Password Please Really Need Replies
