give

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D </thead><tbody> 1 Range 232 To 240 2 3 4 5 Row number 6 232 7 233 8 234 9 235 10 236 11 237 12 238 13 239 14 240 </tbody>...

I just cannot seem to get this right today. I'm trying this: =IF(AND(E4=0,D4>0)*OR(C4>D2),"New",IF(AND(E4>500,D4>500),"Mature","Winding Down")) Not giving me what I want. I want if E4=0 and D4>0 or if C4>D2 to give me "New". If E4>500 and D4> 500 give me "Mature" otherwise "winding down"...

Is it possible to use Vlookup for multiple colummns or even a range and give the value from the next column I want to lookup data in column B, E, H and K and if found give the corresponding values in the next column. i.e if found in E6 it will show the value in F6

I have Filter from A1 to R1, I want that if i filter any cell (A1 to R1) than highlight it with change the colour . so that i can easily find that which cell are filtered. give me developer code etc. please help

Microsoft Excel 2007. Cell C5 contains amount in numerical. Cell D5 contains a code number either 1 or 2 in numerical. Cell E5 and F5 contain formulas to give interest based on C5 (similar formulas but with different interest rate). My request: Cell G5 should give output: Amount in...

Dear All, =""&EOMONTH(DATE(2018,12,1),0) return 43465 last day value But i want the last day value return as 43465.9993055556 value date SoI modify in this formula=""&EOMONTH(DATE(2018,12,1) +"23:59:00",0) to give 43465.9993055556 value. But I won't give. Any Assistance.. Rgds, Aligahk06

If I run an append query will it give me an error message if duplicates primary key field? I have an append query in my database and when I run nothing happens and it doesn't append but it doesn't give me a warning. I gotta figure this out before I start embedding it into macros because if it...

Good day Ineed helpwith the below please If ColumnV is 2 and ColumnQ is equal to Q63 add Column AB, if not give me AB63 in Column AE. Line 196 and 237 works perfect how ever lines 63, 135 an 177 should give me R10 170,00 in stead of R16 995,00. It is also adding line 196 and 237 which it...

There must be a simple thing that I am missing, but failing miserably! I am trying to count (on a master spreadsheet) how may responses have happened in Cell B17 on 12 different sheets of a spreadsheet. I have tried count, counta, sumproduct with istext but nothing seems to give me the right...

Hello: Please help me write a IF state to tell me the value in the box. I want to statement to say if 2 then give me the number 2 or if 1 give me the number 1 or blank leave the cell blank. Or if there is a different function that can do that please let me know.

Hello, I have a list of Data with the following headers: Count, Year, ID. What I am trying to do is come up with a formula that will give me the top 25 IDs for each year that have the highest counts. Basically the table I want to fill out looks like what you see below. I need a formula that...

<tbody> 1 2 2 2 1 1 2 1 1 2 125000 150000 175000 200000 </tbody> I need a formula in A5,A6,A7 that will say if A1 =B3 AND A2 = B4 then give me B5, if they both don't match move over to column C and see if both those match, if so give me C5 and continuing on...

Hi and thanks in advance to whoever would like to take on this task. Please bear with me as English is not my first language, I will try to be as clear as possible. I would be very grateful if you could help me in this query. I would like to count the occurrance of the character S as shown...

Hello Friends, I am using a VBA code to filter record. Here is the code I would like to give a range (D1) in the Field:=2 part of the code instead of "a" Any help will be appreciated Regards, Humayun

I'm trying to write a multiple if(or statement with three data points. IF(OR(AA11046="AAA",OR(AA11046="AAB",OR(AC11046="YES"))),"YES","NO") Brings back "no" no matter what. I'm trying to say if the points are aaa and aab and yes then give me yes. all others should be no. Any help is...

So I have just one table that I added to the data model, to give me some of the flexibility of dax and afford me some practice time. I have a measure that is a distinct count on my "sites" column, to count unique store numbers in my data set. I would like the measure to ignore the filter...

Hi All, got situation -- I have one column (A) and header start from very first row (1) And after several rows header starts again. so whenever I use Find method it give me second match doesn't give first match. Example '''''I enter text "EmpID" in two cell A1 and A2 and excel gives me...

Hello. I’m trying to create a sorting table in excel using drop down menus. For example, column A has a list of college programs. Column B has a list of states and column C has a list of colleges. If I select Master’s Program in Column A for example, it will only give me a partial list of the...

Hi I have scenario like the following: I do not want to allow 2 material to have same week (to be borrowed same week). I want to give a user an message saying he can not have that week because other device reserved that week. For example Device 10 is taken in week 4 then later device 200 is...

Hi Why there is a command to delete a cell? Can you give me please a real life example that I need to use that command. I know I can clear All a cell then why I need to delete it? Thank you.