pretty

Hello, I have the formula: =IF(INDEX('4WK MVT'!B:B,MATCH('Worksheet'!C12,'4WK MVT'!D:D,0))="*"&"DC"&"*",True,False) The end goal here is if the returned result has "DC" in it, I want it to the True, if not, False. Pretty sure I am using the wildcard incorrectly or something. Thank you!

Hi my fellow excel warriors, I am looking for an excel template to track holidays. I have found trumpexcel. com/excel-leave-tracker which looks pretty good but I need it in hours and not days. Can anyone help? Many Thanks

This is pretty fast, is there any quicker? Thanks. LR = [match(2,1/(l21:l<>""))]

Hello, I am starting with VBA and I'd like to know if it was possible to use list from a worksheet inside the code. I wouldn't want to create an array as my list is pretty long. I would like to have an if statement that goes like: If Range("A1").Value IN [a liste of value inside the...

Hi, How do I format number to 2 decimals so that "A$" sign comes on left of the cell box and text on the right (like the $ format coming in the last row) Right now the fomratting looks pretty odd. Image attached. Also while we are at it, how do I have "US$" format? Thanks alot

Hi all... i have a fairly simple problem with what i think is a pretty hard solution (at least to me) so i have a sales comission report and need to pull agent totals to another excel file. Seems pretty straight forward.... Except this report creates a new row per sale... so the totals row...

Hi, I have a list of business names in Excel starting in cell A2 going down to A3, A4 etc. The record-set is pretty large as it contains over 100,000 rows. What I need to do is to retrieve the address for these business using IE and return the corresponding address in cell B2, B3 etc.. I'm...

I've got approximately 200 records, with each record consisting of 12 string fields. I have a two dimensional array. The question is how to declare it and how to load it from the Excel spreadsheet, then how to rewrite the info back to to spreadsheet after the data is changed/manipulated...

Hi all, I am adding a new form to a pre-existing split - database. However, when I open up the VBE, I can't find it. I'm certain this is a pretty simple issue, but I can't find anything similar searching online. Any ideas? Thanks,

I have a formula but I'm not sure how to write "text" into it. For example in cell A1 if text appears I want it to result in the answer in B2. for example" =if(A1=text,1,2) The use of the word "text" clearly is wrong so must be pretty simple to fix?

Hi - this is probably a pretty simple one, I'm trying to write some VBA for 3 Option Buttons. The first two lines work but the third one doesn't. I'm pretty new to writing VBA. Private Sub OptionButton1_Change() If OptionButton1.Value = True Then Sheet36.Range("C2").Value = 10...

I put in the code: Dim wb As Workbook, str1 As String Set wb = ActiveWorkbook And when I look at the info for wb in the locals window for wb it just as no variables. I'm pretty sure that it was working a second ago.

Hi everyone! Pleasure to have become a member of the community. I hope to become a net contributor to the board in the future. Alas, now I will posting (hopefully) pretty basic stuff. I mostly self-taught myself Excel and became pretty proficient from my former job in benefits (typical basic IF...

Hi, I'm pretty sure this is an easy thing but for the life of me I can't figure out how to get this to work... I am trying the following formula in Excel 2010 to find a part of text in a cell and then, depending on whether it finds the text, return the corresponding values...

Hi there, so i have a couple of questions but they the end result is basically the same... i need to delete rows... firstly i would need a macro to delete all rows that contain a lowercase Z (usually should be found in column "A") Next i would need to delete all rows that contain an empty...

I have the following 8A, 20C, 110J. I want a formula to remove the letters from the far right, so that it returns 8, 20, 110. Letters can only be from A-Z. I think it's a pretty simple formula but my brain is making me think of something more complicated. Would like to avoid using any helper...

Hello I have a dataset and I am trying to use a formula. However despite spening ages on it it still not working. I am new to this and am probably missing something pretty obvious, and I was wondering if someone could have a look at it to see if it is written incorrectly. =-1.675 + (0.037*e2)...

Hi all, Long time lurker and first time poster. I regret to make my introduction one where I ask (beg) for help but am at a loss achievable results. I'm compiling some football stats (not soccer). For anyone not familiar with football you have 4 downs to get a min. of 10 yards to achieve a...

Hi, I need help extracting a value from a column to create a second column. A 1. G17 2. G16 3. G16 4. G17 5 G16 6. G17 I want a coulmn of g17 and a coumn of g16, in the current row. To look like this: A B 1. G17 2. G16 3. G16 4. G17 5. G16 6. G17...

Hi All, I'm working with a pretty simple sumifs formula as follows. =SUMIFS(E4:E77,$A$4:$A$77,">0",$A$4:$A$77,"<=A1") However, it is returning 0 when there is clearly data. In cell A1 I have the following equation to identify the last number listed in a column that i add data to weekly...