The discussions
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...
Excel - how to repeat multiple functions
Hello, I'm trying to set up a spread sheet in excel. Following is an example. A1 is say 500 B1 is say 50 and is a number from a IRS table t...
Excel data merge
Hello, I have two excel sheets that are similar. Sheet one has a master list of contractors that are active and sheet two has another list of contr...
Match partial texts with multiple returns
Hello, I have 2 sets of information: 1 simple list of Company Names ( Data-A ) 1 array of data including another list of company names ( Data...
Coniditional formatting
Hello, I am trying to write a code that will scan input dates and compare them with dates in the cell next to them. If the dates input are farth...
Large col. based data to be changed to rows
Hello, I have a large excel 2010 based data file sent by my retail partner. The first 5 columns have the list of my SKUs being sold by them, ...
[excel] macro to add prefix to column
Hi, I recorded the following macro to add a thorn symbol before and after each record in a table. I can't figure out how to edit the macro so that...
How to handle linked cells?
Hello, I am trying to get this formula to work: =IF(T8=0,"100% with PO",T8&" days, NET") T8 is linked to another table and contains the followi...
Match data from master worksheet
Hello, i have two worksheets A & B with different fields but one field is common in both worksheets. I want to get some field from sheet B. Fiel...
Excel row to colum
Hello, i would like a little bit help. i want from this: data1 data2 data3 a 120 20120903 b 270 20120903 c ...
Multiple criteria lookup? if/and statement???
Hello Everyone, This is my first time I'm at this forum and I would hope that someone can help me with a excel situation that I'm trying to resolv...
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
Matching and adding data
Hello, I have a very basic knowledge of excel and am not sure if this can be done however I am informed this is the place to find out. I have ...
Excell find in a cell some text
Hello, I am trying to find in a cell some text. I would want for example in D1 to see if it had: Low Low, if so put a 1 in the E1; High High, put ...
Header and fotter in same page
dear sir, How can I make Heade and fotter in same page? What was the code Thanks
Using if function to create a date
Hello, I am trying to create a cell that shows todays date if another cell has a particular value. The formula I am currently using is: IF(E9=...
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...
Forgot password of micro sd
Hello, i forgot the password of my memory card of my NOKIA N8 mobile. i recently formated my phone so now i need the password to access the card...
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...
Embed macro
Hello, I hope this isn't too much of a nasty one for Friday afternoon! Any assistance much appreciated. Is it possible to run a macro inside of ...
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...
I cannot run keyword elite
Hello, I cannot run Keyword Elite after download. It returns the following error message; The NTVDM CPU has encountered an illegal instructio...
Outlook can't send or open
Hello, Dear sir/Madam In my microsoft outlook 2007, i can't send or open, to read my mails which i receive after clicking on them where ...
Excel formula which calculates start date
Hello, I would like to create a calendar tool that will generate a start date from a set end date that excludes weekends based on processing and t...
Text in macro
Hello, I'm new to writing macros and wonder if anyone can help me with a couple of areas I'm stumbling on? Firstly, let me say that I am wr...
Conditional formatting excel 2007
Hello, I am trying to create a rule that when "yes" is selected in the drop down menu in cell F3 cells from A35:D39 are filled yellow, and if "no"...
Memory card password
Hello, i did not set memory card password but it ask for it. My cell is Nokia 2700 classic. What can i do? Please help me fast.
Setting up excel to pick numbers for my list
Hello, I would like to use Excel program to pick 6 numbers for a list i have. can ths be done? Thanks Configuration: Windows Vista Internet Explo...
Open excel document from desktop
Hello, When I right click the mouse on the desktop, I am unable to open the excel document from the shortcut menu. The excel document does not sh...
Sub:guide urgent
Hello, The following is sample data, i want to sort through month, not year , please guide which format may i use, to sort data. 31/08/2006 31/...
Changing color of a row when typed in...
Hello, I'm making an excel spreadsheet. What I'm wanting to do is have a row turn red if I type something in the first cell. For example: If I ...
Macro to create files based on the contents
Hello, I want to create a macro which creates files based on contents in column AJ. I want the macro to copy the data from original sheet to the re...
Excel date format
Hello, I receive a report that has the date displayed as just numbers. Example: 20120131 How can I change the data to read: 01/31/2012 ...
Unrecongized file data.mdb
ClosedHello, Windows Xp-sp2, i have time card software. backend msaccess files. one particular mdb file corrupted. please give the correct soluti...
Macros in excel so it copies onto next row
Hello, I'm trying to copy values from one sheet to the other in excel via use of a macro. The data is in rows, and is there anyway that I can progr...
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)
Excel help
Hello, I have a sales performance sheet where I always update the sale. There is a column for the overall average sales where I need to upd...
Page number in word
Hello, how to give page numbers in word 2007 in a procedure, where number 1 will be on the right side of page and number 2 will be on the left side o...
Memorycard password
Hello, my memorycard password is blocked my memory is 2GB please help me becaues it is my favourite photos is filled in please help to remove the pa...
Excel: replacing a range with another range
Hello, I am trying to create a drop down menu with 12 options in it that will replace a range of data with another range of data based on what you...
Macro: insert blank row variable n times
Hello, I am building a University Timetable. Each subject we offer occupies one row on an excel spreadsheet, we have about 200 subjects in total. ...
Both rows and columns lookup
Hello, Can anyone please help me on how to set up a formula for both rows and column lookup? here's an example Fruit Price1 Price2 Apples 0.69 0...
Password reset
Hello, How do I reset the administrator password ( I do not have the current password) on a Dell Inspiron 1012 mini with windows 7 starter Conf...
How to delete password on micro sd card
Hello, how can i delete or renew my in my microusing my C3-00 phone. tnx.
Mobile tracker password reset
my mobile LG-T500 settingr are reset..so my mobile tracker number changed..plz tell me how can i reset
How to restore ms starter 2010
Hello, I would greatly appreciated if someone can be so kind and help me with the issue I have, 3 days ago I was deleting some programs that I have n...
Excel 2007 dropdown list from multiple column
Hello, I hope all is well. I am back again with some questions and would appreciate any ideas/tips you may have. I am trying to create a dro...
Help for end-user - hipergate
Hello, I have installed higergate in my system. After browsing through its features, I find it to be an excellent CRM for my use in Sales and Proj...