simple

Hi Team, I'm having a (what I think) very simple SUM issue, but it's a Monday and I can't work it out! Effectively, I am trying to do a COUNTIF and SUM in one. My COUNTIF is as follows (and works, no issues there): =SUM(COUNTIF(INDEX(Data!$F:$AO,,A2),"Strongly...

Hi everyone Please can anyone give me a hand? I have a macro button that does something, however is there a simple piece of code I can include within this macro that will hide another macro button called 'Export' for example? If so, is there then also another piece of code I can use to unhide...

I have a table with headers (starting in A1), nothing fancy. I have a form that controls the data that is entered, works fine. If the table is empty with only the headers there, I get an error (at the Range statement). If cell A2 has something in it it works fine and finds the last row...

Hello, I have this bit into my code, that should return simple "Yes", "No" values present in the range. inclusion = Application.VLookup(Dest, details, 10, False) All variables are defined, inclusion as Variant, Dest as String, details as Range. The problem i am encountering is that when the...

HI all so this is a pretty straight forward and simple question (i think) and please excuse my stupidity if it's something super obvious but.... how is this super simple formula a circular reference??? =SUMIF(N:O,N9,O:O) I get this message after i copy this formula down (say about 10 rows...

Hello, Can anybody help? I have made a form for my purchase orders and all apart from when i run the macro, it works but has a bug with the following Range("E33:F50").SpecialCell(xlCellTypeConstants, 23).ClearContents I am trying to keep a simple formula i.e =E33 Thanks, Richard

Hi, Looking for a simple IF function, I hope lol. If cell A1 is popluated with the word "Can" I want the cell that this formula is in (B1) to populate with the data listed in A2. The only thing I can come up with is IF=(A1=Can,B1=A2), but that doesn't work. Any help is greatly appreciated

Should be an easy one for you guys, I'm trying to produce a time/date stamp without using VB code, needs to be a simple formula. I'm trying this "=IF(F6="","",(now))" but it returns "#NAME?" Any suggestions? Thank you

Evening, For some reason a certain part number in my worksheet doesnt get entered correctly. So can somebody wright me a simple code to find this number in a specific column & once found replace it with the correct number. This is the infro that you will require to assist you. Worksheet is...

Hi All, I'm hoping that someone will be able to help me as I am at my wits end. I have created a cell reference from the tab/sheet name as below: In cell U5 is this =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) This retrieves number 1 for example In cell V5 is this...

Hello, my vlookup did return a value however I thin it is lying to me. When I have a filer on the column and look for the value as a check, it does not appear. When I try a control f the value does not appear. I have not tried an index match yet. Is there a simple formula to locate the...

Good day all, I have a simple issue that I am struggling to resolve. In an access report I have a combobox (Called "InterestCode") that looks up a value from a query and outputs that value. There are a number of options , eg. M1, M2, M3, P1, P2 etc. Depending on this value, I would like...

Been working this issue for a while and haven't been able to solve it myself. I can two workbooks, Rent Rolls and Rent Rec. I have several Named columns on rent Rec to keep things simple. Here is the formula I use in Rent Rolls...

Hi All, Thanks in Advance I am having issues with a script that I am trying to run, when I run a simple query it prints out the result but when I query any table on the DB it does show anything and prompts me an error. I ran both queries on PL/SQL and got the correct results, any ideas why it...

Could I trouble you for a formula to count the number of words in a cell. These are actually names so in an example of Stephen Thomas Smith the answer is 3. Such a simple question but I have thousands of rows that I need to review. As ever my sincere thanks

I have some good samples of Vlookup, where one might want to look up something in one place. Is it possible to do a second vlookup using two search criteria? In other words, if my lookup was a simple one, do that first, and then look up a secondary item, and if it is there return the answers...

In my code, I run into values of a variable (tdur) representing duration (in hours) . These are some examples: 0.53 1.53 2.11 1.06 1.32 2.64 0.26 I would like to round these to the nearest 30 minutes. So, with these example: 0.5 1.5 2.0 1.0 1.5 3.0 0.5 I thought it was more simple than it is.

Hi, Firstly, apologies I am not an advanced Excel user, so please excuse any obvious gaps in knowledge. Essentially, I am using a TimeLine to select a month that adjusts Pivot table information - easy enough! However, I need to extract the month selected in order to apply to a simple...

Hello there, I have the following formula: =SQRT(SUM($N$2:$N2)/SUM($G$2:$G2)) Column 'N' refers to a simple calculation: = B2*B2*G2 Can anyone supply a simple method of combining the calculation in column 'N' directly into the original formula? Thanks in advance, B.

I'm looking for some help designing and building a simple worksheet that allows about 20 users (Mac and Windows) to manage the data in the table while in a filtered view. The core table has about 20 columns, and each user needs to go in, filter for their records using one column, and then update...