good

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...

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...

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...

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")

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!!! :)

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...

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'...

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...

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...

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...

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...

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...

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?

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...

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...

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...

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

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.

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...

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...