Excel Forum - solved topics

Ask a question
Results 1001 - 1050 of about 1,710
  • Solved
  • Conditional Formatting a single cell based on another range Solved/Closed

    I have been trawling around looking for a solution to my problem. I need to highlight/colour a single cell when its value appears in a row elsewher...

    hussar | Latest reply: hussar Oct 20, 2013
    2 replies
  • Conditional formatting a cell if a certain word is met Solved/Closed

    Hi I am trying to conditionally format cell B3 if the criteria in cell C3 = NAT I am able to do it if it was a number but not if its a word, If the ...

    scarey3 | Latest reply: scarey3 Oct 15, 2013
    2 replies
  • if formula showing date Solved/Closed

    Hi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in ...

    simeonmein | Latest reply: simeonmein Oct 9, 2013
    2 replies
  • Excel VBA: Application.FileSearch Error Solved/Closed

    Hello everyone, I encountered error "Object doesn't support this action." when the program the line "With Application.FileSearch". Here is my codes...

    w_l | Latest reply: wliang Oct 8, 2013
    2 replies
  • Conditional Formatting Solved/Closed

    Hello, Does anyone know if you can set conditional formatting to highlight an entire row if the date in a specific cell is less than a week from t...

    antower | Latest reply: Mazzaropi Oct 7, 2013
    3 replies
  • If data matches in one column, check 2nd column matches Solved/Closed

    I've been trying to figure this out for days, I'm sure it's possible but can't get it to work. I have a set of data - in one column there are refer...

    vickylouise | Latest reply: vickylouise Oct 7, 2013
    2 replies
  • Help to convert a date to julian date fromat yyyyddd in excel Solved/Closed

    hi, i have thousands of dates in format dd-mm-yy that needs to be converted to julian date format yyyyddd. dates that needs to be converted are fro...

    seekermay | Latest reply: Calixte DORVIL Sep 30, 2013
    6 replies
  • Is there a way to call out multiple values in single cell? Solved/Closed

    Hello everyone, this is tricky and im not sure if i have missed something or if this is even possible, if it is it would be a huge help. I am limited ...

    Whylucky | Latest reply: Whylucky Sep 26, 2013
    2 replies
  • due date reminder in excel 07 Solved/Closed

    Hello, dear all. I have a "credit list" worksheet having the details like. 1) date 2) invoice number 3) name of beneficiary 4) total amount 5)paid c...

    suryam | Latest reply: venkat1926 Sep 18, 2013
    4 replies
  • ms excel, lookup word from a cell Solved/Closed

    A B C 1 C287198 MARIQ BLDG MATERIAL TRDG C287785 C287785 2 C2...

    Muniz Reza | Latest reply: Mazzaropi Sep 14, 2013
    3 replies
  • Excel Formula Solved/Closed

    I have a blank excel invoice that I want to be able to type the Item number on it and have it populate the vital information on it like the item name,...

    sephiek | Latest reply: sephiek Sep 13, 2013
    6 replies
  • Need Help Please: Excel Click Timer to time each Work/Task Solved/Closed

    Hi Excel Pros, This is my first time to join the excel forums and have seen how helpful you guys are here. I need to come up with a visual basic...

    jsioson | Latest reply: jsioson Sep 11, 2013
    4 replies
  • Copy multiple charts to multiple worksheets Solved/Closed

    Hi I have a challenge for which I cannot correctly conceptualize a workable solution so I am hoping someone here can share their thoughts on it. ...

    ibtrini | Latest reply: ibtrini Sep 5, 2013
    5 replies
  • Excel Macro: Rename all Worksheets Solved/Closed

    So, I'm trying to figure out a way to rename all the worksheets in a workbook. the first worksheet would be "1" (without the quotation marks) and c...

    Bobo | Latest reply: ansvk1 Sep 4, 2013
    7 replies
  • Excel Macro help, hiding columns Solved/Closed

    So I'm trying to figure out an Excel macro that would hide row A-K on every worksheet in a workbook. Thanks for any help

    Jason | Latest reply: Usama Aug 22, 2013
    3 replies
  • Need help to create an excel macro (Combine columns) Solved/Closed

    Hello, Inputs Col A and Col B ( all data ranges are variable), need out put in C Col. (MACRO), I not good at vba/e , kindly help. Col A ...

    sudiptabiswa... | Latest reply: ac3mark Aug 20, 2013
    3 replies
  • add two type mix font in one cell in excel 2003 Solved/Closed

    hallo i have a excel 2003 userform with textbox . I have problem in my data base . I have 2 type font in my data like DevLys 010 and arial. I want to...

    aptpsbwmraj | Latest reply: aptpsbwmraj Aug 17, 2013
    9 replies
  • Recurring date formula Solved/Closed

    Hi All I have the following formula in my worksheet =IF($AA$2=2,B8+28,IF($AA$2=1,B8+7,IF($AA$2=3,EDATE(B8,1),IF($AA$2=7,EDATE(B8,12),IF($AA$2=4,...

    MRafik | Latest reply: MRafik Aug 15, 2013
    10 replies
  • cant format date in excell Solved/Closed

    Hi, When I enter the dates as number with out forward slashes, and format them by right clicking on format cells and choosing date the date appear...

    matia93 | Latest reply: imran123 Aug 15, 2013
    5 replies
  • Lookup same Entry A1 in 2 worksheet & return B1 from 2nd w/sheet Solved/Closed

    Hi, I have 2 worksheets. "Master" = Sheet 1 "Status" = Sheet 2 In "Master" Worksheet there are 3 columns, A1-User ID, B1-Username, C1-Status...

    ozetrezure | Latest reply: ozetrezure Aug 14, 2013
    1 reply
  • Macro Range Solved/Closed

    Hello, I am somewhat inexperienced in the world of macros in excel. I have a looping macro that runs from the bottom and i want it to stop at ...

    Jim Clanton | Latest reply: venkat1926 Aug 10, 2013
    4 replies
  • How to tranfer information Solved/Closed

    I am wanting to set up a sheet that inputs information on another sheet in excel. The problem is, I want it to list the information from one section o...

    CaptnJack2013 | Latest reply: CaptnJack2013 Aug 9, 2013
    0 replies
  • I am just learning the basics Solved/Closed

    Hello All, I am new to this community. I have just started learning Excel and am having a problem with a formula. the community here from what I have...

    itstubtime | Latest reply: ac3mark Aug 8, 2013
    10 replies
  • Create a macro Solved/Closed

    Hello, Please help me. I am new at macros, and I need to create a macro that will automatically total a column as below: # Name ...

    louannc | Latest reply: venkat1926 Aug 8, 2013
    3 replies
  • Need help with an IF function Solved/Closed

    So, I am trying to get this formula to work. The situation is that one of our items have changed names. In the spreadsheet, I am trying to get a f...

    AY44 | Latest reply: AY44 Aug 7, 2013
    4 replies
  • Excel date problem Solved/Closed

    Hi, How can I change the date format from a format such as 22042013 - (this is not a text format). One formula I have been given is: =IF(LEN...

    Nydee | Latest reply: Nydee Aug 7, 2013
    6 replies
  • Any part of string in cell matches part of string in another Solved/Closed

    First post after hours of fruitless googling :-) Working in Excel 2010.. I have merged two data sets and where there are instances of exact dupl...

    Scr33nager | Latest reply: Scr33nager Aug 6, 2013
    9 replies
  • Conditional formatting can't caputure text...NEED VB CODE PLEASE Solved/Closed

    Hello, I understand i can't use c formatting to insert text and therefore am looking for a piece of code that will perform the following. Consi...

    Mounta1n | Latest reply: Mounta1n Aug 5, 2013
    6 replies
  • Conditional Formatting Based On Changing Dates Solved/Closed

    I am trying to keep on top of dates that are changed weekly based on last weeks dates, but i need to highlight the changed cells only. Example: ...

    SpaceMonkees | Latest reply: SpaceMonkees Aug 5, 2013
    4 replies
  • find and compare calues in two columns Solved/Closed

    Hi i need to look for values (strings) in column A and see if exist in column B. if exist return the line number. (tried vlookup but i get only ...

    mswonderer | Latest reply: mswonderer Aug 2, 2013
    2 replies
  • Help with cell programming! Solved/Closed

    Hi everyone. this is my first time here, and in desperate need of help from some Excel Genie to make my wish come true! Ok, here is my "urgent" pro...

    ozfox999 | Latest reply: ozfox999 Aug 1, 2013
    10 replies
  • Conditional Formatting in Excel2010 Solved/Closed

    I wish to have the following CF in more than three colours. I have placed the following in Data List L1,L2,L3,L4,L5,L6,M7,M8,M9,M10,M11,H12,H1...

    pjevans | Latest reply: Peter Jul 30, 2013
    2 replies
  • Help needed in using marcos Solved/Closed

    Hi, I need to write a marco that is able to compare the specific column in 2 different worksheets within the same workbook. (i.e Names of staffs) ...

    Asmodeux | Latest reply: Asmodeux Jul 30, 2013
    4 replies
  • CONDITIONAL FORMATTING IN EXCEL - off of a range of cells Solved/Closed

    Hi I've never used these forums before but this issue has been bugging me for some time now.... so i thought i would leave it to the experts.... I...

    Mounta1n | Latest reply: TrowaD Jul 30, 2013
    6 replies
  • macro Solved/Closed

    I want to write a macro from the start, I have date of employee name and their attendance on a workbook and on the other workbook I have a calendar. N...

    Ratimorake | Latest reply: Ambucias Jul 24, 2013
    1 reply
  • Excel help on IF formula Solved/Closed

    I want to say IF cell L27 equals the word 'low' then do sum of cell x * cell y, if cell L27 equals the work "expected" then do Sum of Cell a * b and i...

    BruceCurry | Latest reply: ac3mark Jul 24, 2013
    5 replies
  • combining two separate macros into one Solved/Closed

    Hello, I currently am using these two separate macros independently but would like to combine them into one with the archive one being first. I'm...

    kat | Latest reply: Devarajan Jul 23, 2013
    8 replies
  • Macro to Search/Replace Text from another Column Solved/Closed

    Hello, I didn't realize I was being rude on my previous post, that wasn't my intention. I tend to have a "too the point" personality sometimes, and...

    mylove0mylife | Latest reply: mylove0mylife Jul 18, 2013
    2 replies
  • urgent ansin excel Solved/Closed

    a table caring 4 rows, first row is Name, second is address, 3rd row is date, and forth row is house name. how i arrange this in excel in date wise...

    archana. | Latest reply: venkat1926 Jul 18, 2013
    1 reply
  • Popup reminder based on date and additional celll values Solved/Closed

    Hi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long tim...

    MikeTis | Latest reply: MikeTis Jul 15, 2013
    10 replies
  • Hide rows with zero value in Multiple sheets Solved/Closed

    Please help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...

    issa abu Ham... | Latest reply: Excellent answer Jul 10, 2013
    2 replies
  • Conditional formating Solved/Closed

    I have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...

    jgmb | Latest reply: jgmb Jul 9, 2013
    10 replies
  • Convert a date field in excel to day of week Solved/Closed

    Hello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...

    C | Latest reply: Indian Jul 7, 2013
    7 replies
  • some help needed about IF function with dates Solved/Closed

    Hello, i m making a sheet with this function =IF(H1

    rizwan32 | Latest reply: sgmpatnaik Jul 5, 2013
    3 replies
  • creating pdf from selected cell range Solved/Closed

    Dear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...

    cvsuryam | Latest reply: sgmpatnaik Jul 4, 2013
    1 reply
  • how to compare two coloumns in excel Solved/Closed


    vijay | Latest reply: jhanvi Jul 4, 2013
    11 replies
  • Trying to write a code to insert a blank row above a cell value Solved/Closed

    I am trying to write a code that will auto insert a blank row above a certain cell value ie: existing: Column G 5 10 20 22 999 2 22 55...

    Kwanni | Latest reply: Ambucias Jun 26, 2013
    3 replies
  • I cant open my exel .slxs files Solved/Closed

    Hello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...

    srf91 | Latest reply: srf91 Jun 22, 2013
    6 replies
  • Enter Time by clicking on a cell Solved/Closed

    Hello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...

    jkdurkin | Latest reply: totzkie10 Jun 21, 2013
    7 replies
  • Conditionally insert a duplicate row Solved/Closed

    I have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...

    acohen12 | Latest reply: TrowaD Jun 17, 2013
    7 replies