Search:

Type: Posts; User: Rick187; Keyword(s):

Search: Search took 0.00 seconds.

  1. Dependent dropdowns + Output with conditions

    Hi,

    I have already setup dependent lists for example if in the "Region" drop down in Cell E4 if you select "EMEA" then all EMEA countries will display in the drop down for cell E5.

    This is what...
  2. Re: IF value is same in two columns then display a third value from another column

    They contain text.

    In Sheet 1 If the value from A2 is contained in a range from another sheet (Sheet 2 Column G), then Display the corresponding Value from (Sheet 2 Column I)

    So if I have the...
  3. Re: IF value is same in two columns then display a third value from another column

    This doesn't seem to work. Nothing displays when I use this formula.
  4. Re: IF value is same in two columns then display a third value from another column

    Unfortunately this doesn't seem to work when the columns are in different sheets.

    I've tried this: =IF('Sheet1'!A:A=Sheet2!G:G,Sheet2!I:I,"")
  5. IF value is same in two columns then display a third value from another column

    Hi,

    Does anyone know which formula can achieve this:

    If value in column A is the same as value in column B, then display the value from Column C

    For example if Column A contains these values...
  6. Insert count based on word in another cell.

    Hi,


    I would like to get the total count based on a word that is contained somewhere in another column.


    For example:


    If the value of columnA contains the word from ColumnB then insert...
  7. Re: Copying Large columns and rows not working

    I've tried highlighting the whole column and copying

    I've tried using CTRL + Shift + down but that only highlights the first 600 rows, then I have to keep pressing it for about 10 mins for it to...
  8. Copying Large columns and rows not working

    Hi,

    I have 90,000 rows in a spreadsheet, some are blank and some contain text.

    I want to copy all 90,000 rows for the column to another spreadsheet, but when I paste it in the other...
  9. IF value in column matches another column, then insert text

    Hi,

    Is there a formula that will insert specific text in a cell if any of the cells from column A are equal to the names in Column B?

    For example

    Column A contains

    123
    456
  10. Insert value based on another column in different sheet

    Hi,

    I have a list of email addresses in a spreadsheet. I have another sheet in the same excel with a Pivot that allows me to filter based on city. For example if I filter the city by "Amsterdam" I...
  11. Replies
    3
    Views
    176

    Formula for working days?

    Is it possible to create a formula which tells you the total number of working days (Monday to Friday) in between 2 dates?

    For example,

    I would like to have 3 columns with the first column...
  12. Replies
    1
    Views
    153

    Count ifs with cell reference?

    Hi,

    Is is possible to add a cell reference for the text in a count ifs formula?

    Here is what I'm trying to do:

    I have 195,000 URL Links in one column, I have 2,000 unique URL's in the other...
Results 1 to 12 of 12