simple

Hi guys, i know there will be a simple solution to this. How do I get for example 90.7% to show as .907. Many thanks, Jim

Hello In C6 I put 3. In C15 I put: =IF($C$14:C14<=C6,0) However the C15 says FALSE iinstead of 0! Why that? It's so confusing!

For this little guy: =SUM($A$2:INDEX(A:A,ROWS(A:A))<wbr style="font-family: Arial, Helvetica, sans-serif; font-size: small;">) The only reason a simple =SUM(A2:A10000000000000) won't work is because too many lines are getting deleted with each update, and I'm trying to avoid having to check if...

I've searched the wonderful world of Google for a simple answer and wasn't able to find one. Is there a simple way to have a standalone (manually executed) vbscript to change an Access query parameters? I have the same parameter in three queries, which is Like"XXX" I need to replace the XXX...

Hi everyone, Hopefully a simple one for someone but I cannot get it to work! I’m trying to convert all currencies on a spreadsheet to USD Column B has the base price, Column C has either (GBP,USD,EUR). What I am wishing to do is in column D show a USD price only , so if column C says GBP or...

Hi Mr. Excel Family, I know I am overthinking this and its probably simple so here goes: I am trying to set "ChartRange" as a range that includes cells H5:K5 and everything below as the range of cells to use in a chat. For some reason, I can't figure out how to select the original range and...

Hi - first time posting here. Hope you can help. I'll try and be as clear and as concise as possible. I have 12 questions (which form part of an assessment). Each question carries a simple "Yes" or "No" answer. This gives me 4096 different possible outcomes (2^12), for a completed assessment...

Hello to everyone I have this situation In colmun A i have a simple numerotation A1=Row() Which is formula for keeping continue numerotation after i deleted a value or values from this range? Thank's A B C <tbody> 1 1 1...

I'm really new to VBA coding and would highly appreciate if you can help me with the error as per the screenshot <a href="https://ibb.co/hmRVfHr"><img src="https://i.ibb.co/ZM6xmKv/Compile-error.png" alt="Compile-error" border="0"></a> https://ibb.co/hmRVfHr

The macro reads in about 30,000 records does some simple, very simple, editing and that's it. One column sometimes has missing data after the macro runs. Sometimes many of the rows are affected, sometime all of them. I'm pretty sure the problem is something in that column. I've tried my...

Hi, everybody Suppose I have a simple button (not a toggle button). I want it to run the macro "Macro1" when I click on it the first time, and run "Macro2" when I click it a second time. If I click it a third time, it will run "Macro1" again... I want something simple, because I will later...

Hi. I am trying to create a simple update checker, but not sure how to proceed. What i got is this: A workbook that is called VData.xlsm, with a button which has me.userform1.commandbutton4.visible = false Now, what i want, is every 1 min, the file checks another workbook, which is called...

I have a "simple" problem, and I am not sure whether to tackle it in VBA code (which I know will work, but may take longer) or with some simple, yet elegant, Excel tricks. Let's say I have a table like this: I will be receiving an input file with hundreds of rows of *ONLY* the first row of...

Hi guys, I need someone’s brain on this. Sounds super simple.. but it just doesn’t work when I try it. I looked at all the previous 50 pages of posts with the works Pivot/stacked charts, but couldn’t find help. I am trying to do as simple stacked chart out of a pivot table. But when I...

I can't figure out why this won't work. Can someone take a look? Private Sub ClearContents() Worksheets("Costing").Activate If Cells(7, 5).Value = "Other %" Then Cells(7, 7).ClearContents End Sub

Hello Mr. Excel Gurus, {=COUNTA(IF(CELL("format",B2:B18)="D4",C2:C18))} Above is my simple formula that counts the values in column C if the values in column B is in Date Format. Isn't working, any solutions please? Thanks

Hey Guru's!! I've done a counta =COUNTA(L4:M10000) which gives me every cell with data. but ....... I also need unique's in that if L4 and M4 both have data it's only counted once? I know it's going to be something simple that i'll smack my forehead in shame for after but you guys always...

I'm trying to find a method to identify if a specific module exists in a project. I've tried this but it doesn't work - is there a simple solution? If ActiveWorkbook.VBProject.VBComponents("Setup") <> "" Then

Hi, I know this must be a simple answer, I have the following cell D5 = A5, and E5 = A6. I want to be able to drag these down so D6 = A7 and E6 = A8 and so on down. Obviously i am dragging and getting D6 = A6 and E6 = A7. what is the solution? Thanks J

hi, Obvious newbie question: I'm working with a fairly large list of information, not very complex, but spread over 50-some worksheets in one workbook. I'd like to create a blank worksheet with a simple searchbox and a simple button to click. The results of the search should be displayed just...