great

Afternoon All, i have an excel doc with a Vlookup formula that has worked fine for a long time, now it isn't working and i can figure out while. the formula works great until i autofill but dragging down the the little square in the corner, then the values all mirror the first value instead of...

I can't remember exactly how to do this one so if someone could help that would be great. I'm looking to add everything that's in column F if column B is the number 1033. how do I do that?

Hey All, This formula is really simple but way too long. There must be a way to make it shorter but I'm not smart enough to do it. Any help would be great...

I am trying to hide row 129 across these sheets. It works great but when done all the sheets are high lighted. I want it to return to sheet "Chart of Accounts" only. It doesn't mater what cell. Any help would be great. Thanks Sub Line129callapes() Sheets(Array("January", "February"...

Hi All, I've got a basic count formula of: =COUNTIF(P$3:$P$208,">0") I also want to add to this formula to only count C3:C208 if the result is great than 0. Can you help?! Many thanks, Russell

Example If i were to input a value '240*' in Cell "A1", it will auto filter another column in another sheet column D Is it possible? I would like to use the cell to filter instead of using the filter option? Would be great if you guys can come out with a script. Thank you in advance and and...

I am terrible with excel and have been banging my head against a wall. I do some community volunteering and am trying to come up with a way to manage staff. Each month I get a spreadsheet which I want to load in as a sheet and have another sheet to use as a dashboard. It will need a search...

I have another formula that is sorta working... I have it in another Workbook and it works great.. All i changed was the Table and Header info and it works but is a little wonked... =IF(ISERROR(INDEX(DRMRwdData[#All],SMALL(IF(DRMRwdData[Store '#]=$B$1,ROW(DRMRwdData[Store...

Hi, I am looking to hide an array of worksheets as shown below; Worksheets(Array("Data Log", "Rev. History", "Visual Set Point")).Visible = False This works great to hide the worksheets, however what I am really looking to do is, very hide the worksheets, something like this...

G'day! I currently have : =SUM(IF(FREQUENCY(A8:A1000,A8:A1000)>0,1)) It batches column A with re-occurring values and gives the number of batches this works great! However, I now want to look at column H:H and see how many batches from A:A have the value "MG" in column B. See example below...

Dear MrExcel Forum, Thanks for everything. I've been coming here now and again since I started using Excel and every time have had quick replies and great answers from your active and very knowledgable board participants. This clearly is a very well managed message board and provides a great...

Hi Folks, I have quite a large sheet formatted something like the below. Blank cells share common data with the populated cell above them, maybe not great formatting but it is what I get. I would like to be able to sort or filter by location for example with the empty cells below South3 being...

All, I have an xy scatter with dates up to a year with minute data. I want it in an xy scatter but I want to be able to pick a date range without editing the axis. Any help would be great. thanks

Hi, I am trying to highlight if an allocated booking time goes over 30 mins - any help to do that would be great! Thanks

Hello , A very warm Hello or Hi to everybody from Ireland I have just joined my name is Maureen, Not great on computers but using excel for a small craft business I am trying to get going. Can anybody help? I need to insert the number 0 in selected cells , is there a quicker way to do this...

How do I remove everything in a cell that comes before the final set of characters "..." In this example of how the data in the cells appears, I would like to have a column next to this that would have just "Melbourne" (if I could eliminate the ending period "." too that would be great. ACE.AU...

Hi Everyone, Firstly just looking for ideas I can try out so if you think you can help let me know. I have a macro that runs great, its one that takes data one row at a time and finds were to put it on another sheet. I'm sure you know what I mean when I say it does the x = 1 to lastrow...

Frank here. Can anyone help me work out how to: A1 to A60 are numeric. I want Column 'B' to make a progressive descending total of Column 'A' figures. New at this so yes help would be great, Thanks, F PS: What does it mean when it says here something about 'Tags"?

I currently have a workbook that when data is entered in column A it will return a time stamp in column I with the help of the if statement. This works great however it makes my workbook very slowwwww. Is there another way or a VBA code that could do this same thing that could improve my...

Hello, I have created a userform but am having trouble figuring out how to input the code. I want it to input the values that are typed into the form but only the ones that have values. It would be great if it could also state what the tender is i.e. cash, debit... etc. Any help would be...