• Search for duplicates in a collumn and delete the row on which it occurs

    Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather avoid...

    Harleq20 pointsBadges:
  • Linking Information in two seperate Workbooks

    I need to create a Workbook that has certain cells accessible for people to enter in their information and then have the ability to pick from a drop down list that will auto populate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens...

    CleanEnergy5 pointsBadges:
  • Problems using VLOOKUP in Excel 2003 spreadsheet

    I have an Excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a...

    Ironsprings5 pointsBadges:
  • Exporting data from SSIS to Excel

    I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I go about this?

    WindowsServerATE335 pointsBadges:
  • MAXIF formula in Excel

    Excel has SUMIF and COUNTIF functions, but I don't find a comparable MAXIF function. Can such a function be added into Excel? Any suggestions for sources?

    TomGlass20 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 pointsBadges:
  • Excel Function Help

    I am designing a spreadsheet to keep track of various data. I have a list of birthdays (month and day in separate columns) and I would like to pull the person's name that corresponds to the particular month. I have attempted to us the lookup function for this, but if there is more than one person...

    Trakaszcie5 pointsBadges:
  • Excel 2007 what is the command for scrolling down your rows with still seeing the header row at the top

    I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. Thanks so much!

    Buddyboy12310 pointsBadges:
  • Deleting successive rows on Excel 2007

    Using VBA in a large timeline excel worksheet of 50000 rows. How can I automatically delete every 3 rows and leave the 4th row so I can reduce the number of rows to about 12,000.

    Debress5 pointsBadges:
  • Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • Automatic date

    How can you set up a cell to activate the current time when another cell has data entered into it? Just want to track what time DATA was entered in the other cell.

    Bispo120 pointsBadges:
  • Current column name in Microsoft Excel

    Could someone tell me what the function is to get the current line number / current column name for cells in Microsoft Excel? Thanks!

    ITKE352,565 pointsBadges:
  • VLOOKUP in Excel 2007

    I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

    Newkid4735 pointsBadges:
  • Put rows in numerical order

    I have data entered randomly and now I want to sort it numerically using a certain column as the numbers to sort.

    Kooka5 pointsBadges:
  • How to connect to quick 3270 secure screen through VBA macro?

    Hi, I use the following code to connect to quick 3270 macro and it also connect to the screen. But when I run the macro for the first time it works, but does not work when I run the same macro for second time. If I restart the mainframe then the macro runs. Below is the code. Sub getdata() Set...

    Anirudha0075 pointsBadges:
  • How can I retrieve an Excel file saved in Hotmail?

    I opened an Excel attachment in Hotmail and started editing. I saved it continuously but when I closed Excel and reopened, the file was gone. I'm running Office 2007 and Windows 7 64-bit.

    Mohanb5 pointsBadges:
  • How to collapse data in a Pivot Table in Excel 2007?

    I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collapse all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to collapse.

    Babyphat5 pointsBadges:
  • Compatibility mode

    My Excel documents are saving in compatibility mode. How do I change this?

    jlynkett75 pointsBadges:
  • Excel 2010 Second drop down based on first, not working

    I have tried a number of different formulas and data validation scenarios but I have not been able to get my second drop down to recognize the choice in the first drop down. I have a chart of sizes (including fractions) and several weights for each size. I want the weights in dropdown 2 to be only...

    jacktal5 pointsBadges:
  • Excel 2010

    The averages in several columns do not include the product in row 4. adjust the functions in these cells so that all products are included in the calculation.

    enforcer310 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following