ideas

Hi there, I received a file from a partner in poland and the values in their report are displaying as the following: QTY Buy In Unit Price Amount 2 173,599,999,999,999,000,000,000,000,000,000,000,000...

Hi all, i have the following formula =IFERROR(LOOKUP(2,1/(($BJ$3:$BJ$5002=C5)*($BK$3:$BK$5002=I5)),BO5),"") Which should return the contents of BO5 but infact returns BR5 ? Any ideas why this would be? It works fine if used on row 3,4 etc Thanks for any help

I would like to be able to highlight, copy and paste to a new sheet "New C#'s" via a macro, automatically selecting all rows from column a thru P. The sheet is in a table format and the results would be filtered. I can not seem to get this to work. Any Ideas?

I'm trying to figure out how to remove a value from a list using VBA, i have a name range for input, what ever is captured in that cell should automatically be deleted/cleared from worksheet 2 - column G any ideas on how?

I have a field which is supposed to be a date field containing dates as like 24 June 2018, 19:30. I have tried many formulas to try and get just the month I.e June into a new cell. Any ideas?

Hello, I am trying to add dynamic range and sum_range to sumif. Sumif it's not showing any error, just showing a blank result. Any ideas??

I'm trying to use a formula to count the number of cells with a divisor of 6 in but I'm having trouble.. I've tried =SUMPRODUCT(--(MOD(F11:J11,6))=0) but it doesn't seem to work - any ideas??

Hello, I have 6 Excels files. I am using one file as the main file, and the other five I am using as data connections for the main file. My code is as follows Sub DataRefresh() Dim wkb as Workbook Set wkb = Workbooks.Open("filepath") wkb.RefreshAll (This is where the debugger says the error...

Hi all, I am setting up a calendar / planner on excel at the moment and I need the exact same text that I have typed into the first sunday cell to repeat on each every other sunday cell but at 9 weekly intervals. Anyone any ideas? Much Appreciated

Hello All, I was trying to Log off my colleague system using vba. Can any one suggest me with code or ideas. Thanks, Sasidharan

hello I'm looking for ideas for a weekly timetable to my company. timetable is edited every week, there are 5 workers, each one of them has own line colour, I made a hourly grid where his colour showed his avaliability but in my opinion it becomes chaotic. Next, filled in colours table goes...

I have a simple formula X>X where the values of X are decimal numbers returned from an API from CoinMarketCap (cryptocurrency prices). Excel is telling me that .0001 is greater than .0002 I tried using the max formula too and that worked for some cells and not for others (no pattern to this)...

Good morning, I would like to know how to write an IF statement that is capable to do the following: =IF(C3:I8)(Sheet1) contains "5229" then copy A3 of same row(Sheet1) and paste to (Sheet4) B2 Any ideas? ;)

Hi, Not entirely confident this is possible, but here is my situation. I have 6 cells with percentage values in, I have hard typed these values in. What I want to do is to be able to adjust one percentage value and the other 5 percentage values automatically update but keeping the...

Hi, I am trying to see if the data in sheet 1 is also in sheet 4 I have used the following code =ISNUMBER(MATCH(A2,Sheet4!A:A,0)) then drag this down to the last row I then filter out the "TRUE" rows and should end up with the correct answer But the answer it gives cannot be correct as sheet...

Hi Everyone, Not sure if this is possible, but hoping for best ideas. I have a sheet I input Start dates and end dates into for my projects Because one of my superpowers is not Duplicity I can only be in one place at a time but sometimes my brain forgets that! So Simplisest solution when i...

I'm tring to allow users to group ungroup, the code below won't let them use this function. Any ideas? Thank you. Sub protectall() Dim ws As Worksheet For Each ws In Worksheets ws.protect AllowFiltering:=True, AllowUsingPivotTables:=True ws.EnableOutlining = True Next ws End Sub

Hello I am using office 2016, and I want to know is there a way to disable the annoying pop up when you open a file that has links I want to get rid of this: https://imgur.com/a/ilt9U And have only this: https://imgur.com/a/axifr Any ideas ? Thanks

Hi, I am successfully able to pull text from a section of a web page into a string variable, but I seem to be limited to ~1016 characters. Any ideas what might cause this? Thanks.