exel 2010

  1. 2

    DAX 'IF' question

    Hi all, I having issue to "search" for specific text when I use IF faction at Dax. I have the next code: =IF([TesterName]="G1", IF([status] = 'Active',[status],[status])) that should search for "G1" under "TesterName" column. My problem is that at Testername column data is XXXXG1, CCCCCG1...
  2. S

    Freeze Panes re-setting after a Custom View?

    I hope there's an explanation for this. I'm setting a custom view that has certain sorts set on my data. I'm filtering by columns E and I. Once I've applied the custom view, I go to Data-> Sort & Filter-> Clear so that I can see all of my data again. When I do that, the data that was filtered...
  3. J

    VBA or Excel to Auto Filter

    I have a list of numbers referencing an item in column B of sheet 2 that can be found in col A sheet1. I want to auto filter column A in Sheet 1 for rows that contain this number in col A Sheet 1. The number can appear multiple times in column A Sheet 1. <o:p></o:p> I tried VLook up. However, it...
  4. N

    read file size and Write it to exel

    Hey guys! I have a csv file like this. 2012-09-10 meat spaghetti 2012-09-11 fish fish and chips 2012-09-12 meat hamburger etc. etc. and I want to read it and write it to excel. So far I have come with my code but I'm stuck. so I wonder if anyone has some tips or can help me? I was...
  5. M

    If and or functions help!!!

    EXCEL 2010 I am trying to do the following IF in sheet "Main Console" cell "E19" displays an 11 and "F19" Displays a 9 OR cell "E19" displays a 9 and "F19" displays an "11" AND cell "G19" displays a 3 show the following - 20% otherwise display blank Here are the formula's I have tried...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top