excel & lookup & search

  1. P

    split cell data into row

    Hi, I need help with this query-I want to split the data present in one of the column to multiple rows keeping all other info same.I am using excel 2013.Vlaues in column D will be multiple and separated by spaces.for eg- Input Columns value- A B C D...
  2. E

    Show Range of Cells based on Cell value (multiple cell values or buttons) – Excel VBA

    <tbody> I want to display/show columns based on cell values or button commands – VBA Eg : I am trying to compare monthly sales values for the period Jan to Dec via VBA Code, I want to show only two columns (range of columns) for two months which I am comparing among 12 months. So if I...
  3. O

    Confused and Need Help w/Vlookup

    Dear Excel Wizards- I have a list of about 105,000 email addresses in Sheet1, and in Sheet2 I sent a opt-in/opt out email to 15,000 contacts. Now I am trying to separate out the action each email took IF they were the lucky 15,000 list- bounce, clicks, unsubscribe, opened, etc. using a...
  4. T

    Conditional IF statemet that prints if TRUE

    I have calendars for the whole year created inn excel 2013. Each month a page. Different churches are scheduled each day during the year. I need a way to prit the calendar for each individual church that doesn't show others for privacy reasons. For example: IF "First Baptist", BOLD...
  5. N

    Transform and tabulate rows of data in specified format

    I am wanted to simplify the task of transforming 1000's of data in rows into a table with specified column headings. I do manual copy paste of data which is tedious. <colgroup><col><col><col><col></colgroup><tbody> g l m 1 PT-55002 0 135 2 PT-55002 0 135 3 AIT-98932 -200...
  6. R

    Best way to combine two excel worksheets

    I've the below two excel worksheets Sales and delivery sheet. Both worksheets contain 1000 -1500 rows and 40 columns. I need to combine both these worksheets in to a new worksheet " Worksheet 3" which contains combined data from these worksheets. In the below example I've given only 3 columns...
  7. J

    Copying rows and columns from a table to a separate sheet based on a ticker

    Good afternoon, I've spent most of today attempting to automatically copy a number of rows of data from a table into a separate sheet. The idea is that I enter a ticker into a cell and the formula will retrieve the data from the different rows and columns in the table. VLOOKUP does the job, but...
  8. F

    Date formula to find value

    Hi, I have below table1 (sheet1): <tbody> <tbody> StartDate(A1) </tbody> <tbody> EndDate(B1) </tbody> Month(C1) Quater(D1) Year(E1) <tbody> 29/07/2012 </tbody> <tbody> 25/08/2012 </tbody> 1 Q1 <tbody> 2013 </tbody> <tbody> 26/08/2012 </tbody> <tbody> 22/09/2012...
  9. R

    Return Row Header for multiple occurences with a formula

    Hello. I did a search and really couldn't find anything that returned row header information for this kind of problem. Hopefully someone here can lend me a hand. So here is what I am trying to do Name English German French John Yes Yes Yes Kim Yes Yes George Yes Yes...
  10. G

    replace the list of words with selected list of words. and change the time automatically

    i want to get automated add time for every 00:01:05, example 00:00:00,00:01:05,00:02:10,00:03:15. like this i want upto 5 hours.... example : <tbody> A(original) B (time changed) C ffmpeg -i zxcv.mp4 -ss 00:00:05 -t 00:00:7 -codec copy output.mp4 ffmpeg -i zxcv.mp4 -ss 00:01:10 -t 00:00:7...
  11. G

    Remove Duplicates and Find and keep the Most Recent Report

    I have a data base that has over 200k rows. They are individuals that have been termed from the company. The issue is that from multiple reports I merged together, I have the same Employee showing up multiple times based on the fact the reports that the data came from shows him up more than...
  12. V

    Vlookup #REF error

    I am having a problem with my Vlookup formula I am hoping that I can get some help. The formula is on Sheet1 cell Y15. I am trying to do a lookup based on account number on sheet 1 and 2. on Sheet 1 the account number is in Column C the column header is C11. On sheet 2 the account # column is...
  13. E

    help needed for excel lookup tables

    Hi there I'm needing support with my excel file see below. I want to look up Supply & demand tab for each col search if value 0 whats the role and project then lookup Supply tab using input role and project output name or names of resources.... can this be done? Your support is greatly...

Some videos you may like

This Week's Hot Topics

Top