good

  1. E

    Which is the correct syntax to use in this example formula?

    Hi I am still learning Excel and I am very grateful to the good folk on here who generously give their time to answer all of our questions - Thank you. I am writing a simple If formula that looks at cell B1 and if B1 contain the number 1 the formula does one thing but if it contains a different...
  2. L

    vlookup with structured table (Insert-->table)

    Hi Is it good idea to name insert a table (Insert-->table) on the sheet I am working with when I use Vlookup() function? vlookup(x, table1, 3,false) I thought it is not good idea because if the lookup value (x in this case) is not in the first column then I need to highlight the range to make...
  3. L

    using 0 instead of # in custom number formatting

    Hi I just watched a video on youtube about number formatting. I took screen shot of all the codes he was using, please see below. He only used 0 instead of #. I thought that is good idea because with 0 you can represent both the number and the zeros while with # you would only represent number...
  4. J

    SUMIF(INDIRECT to ignore #N/A

    Good morning, I'm struggling to get my formula to work. I know it should look something like this but it doesn't seem to like me =SUMIF(INDIRECT("'"&$D$5&" Patients'!V2:V3,"<>#N/A")
  5. O

    Dates in one column (K) £cost in another column (M) - How do I get cell Q1 to display all values up to a certain date (20th of the month)

    Hi, I am not even sure how to search this. I can find COUNTIF statements but they re only good to tell me how many days fall between before the 20th. Sorry if this is a dimwit question! Thanks in advance!!! :)
  6. H

    is it possible to see a part of a text in Cell ??

    Hi, is it possible to see in a Cell "Good" if in it is "Good Day"... Is it a suitable Text Formatting to do it ?? Best regards, hurgadion...
  7. A

    Stats functions - testing hypothesis and correllations

    Hi, I have the below data which shows the comlaince rates and grade bandings for 26 different audits carried out. the date range over which each audit was carried out has been given a weighted score. I have a hypothesis that the lighter the weighting the more likey you are to get a 'good'...
  8. A

    Count number of unique values based on criteria in other rows

    Hey Guys, I am new to writing formula. Can you guys help me with the below problem? Thanks. I want to write a formula in separate cells, where it shows the unique values of column A when a criteria is selected in Column B. Eg. Cell 1: good: 3 (101,101,103,103,105) Cell2: bad: 3...
  9. muhammad susanto

    Vlookup Problem

    hi all.... how to fix lookup problem this below table : <tbody> seq # B RR RB 1 - - 1 2 - 1 - 3 1 - - 4 1 - - 5 - - 1 AS CLUE : B as representative GOOD LOOKUP : 2 RR-------------ENOUGH RB-------------BAD expected result given...
  10. P

    IF Formula for Greater Than or Less Than with Time

    Hello First off Thank you in advance! Here is my set up in 1 cell (AG33) I have the current time using the =LastModified(K4) in the cell below it I'm trying write a formula that if the current time is before or = 11:59 AM it returns Good Morning but if the time is after 11:59 AM but before...
  11. B

    Tips before starting - how to display several data of one owner?

    I have pretty much only done one larger build with access. Now im starting to preper to redo everything, build it from scratch and make it a bit better from all the stuff i´ve learned so far. But before i start id like some tips on how to design the tables best. Currently i have quite large...
  12. E

    IF function issue

    Below is the IF formula I am trying to use, if there is a number in column A or B greater than 0 in the I would like the result of "Good" if there is any other value in the cell then I would like the result "Unassigned". If there is a number in column A then I get the result I am looking for...
  13. Y

    Put a word in a column based on value of another column

    Hello, I would like to put the words "good", "bad" or "average" based on the value of another column. the values in Column "A" are from 1 to 10. If the value is 9 or 10 I would like to put "good" in column "B". If the value is 6-8 I would like to put "average" and so on. Can anyone assist?
  14. stooly

    Where to start as a programmer

    So I have recently decided I have really had enough of my mundane job and want to try to pursue something I enjoy. I have always wanted to program, I did attempt to try to teach myself a few years back & it went well, it's just hard to juggle a full time job and a family at the same time. But...
  15. Amosbroker

    CountIF When Looking at Other Data

    I am looking to count values if there is data present in other columns. I am creating a cohort trend and only want to count records for which both years have a value. See below, I do not want to count previous or current year category due to current value being unknown for red record. How do...
  16. J

    Comparing multi rows and columns over 2 sheets help please

    Hi all, I have a workbook with two sheets and I want to compare between the two where a system name matches. Both sheets look something like this: Column C -------Column L System Fred --- Good System Trev --- Fair System Trev --- Poor System Bob ---- Excellent...
  17. Guzzlr

    MS Project

    Hello All, I need a good forum for MS Project.. Can someone lead me in the right direction? Thanks
  18. L

    dec 31, 1899

    Hi I know I can not enter that date 31/12/1899 in excel because the first day is 1/1/1900. What to do if I have application need to enter date in 1899? excel wont be good choice for that application for example? Thank you.
  19. H

    Excel Report Templates

    Good afternoon All, Was just wondering if there are any good sites with excel report templates that I could "borrow". Looking to create some eye catching but simple reports, but cutting on the design time. Interested in both tabular formats as well as graphical presentations. Many Thanks...
  20. K

    Auto Sort Macro

    Good morning! I've read other Auto Sort threads, but can't seem to adjust them to fit my data - not very familiar with Macros... I have data in F3:N1440 I would to auto sort whenever a new entry is made in column H. Sorting column H by Font Color (white on bottom) and then oldest to newest...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top