issue

Hello, I’m having a difficult time creating a function that allows me to combine texts. Suppose I have a data set as shown in “data set” and would like to know if a sentence includes that specific text. I successfully made a set of functions including find/lookup/iferror which provides...

ok folks ... I'm grasping at straws here. A couple of times recently a colleague has had a problem that I have resolved as being caused by the formula calculation option being set to Manual .... it wasn't too much of an issue because I knew when she called what the problem was. However the issue...

Is there a way to tag a post to follow? In other words, it would nice to be able to refer back to see what the resolution to the issue was. Thanks!

What is the best way to insert images into New Threads? I cannot seem to get this feature to work. I am using Snagit to copy screenshots which will assist me in posting my thread and showing exactly my issue, Thank you.

Hello I am trying to print and have the vba code adjust margins so i don't have to every time. The issue im running into is that it wont print it to a 11x17 pdf size and it wont fix the margins for me. It wont print to scale. Anyways it keeps saying "Document not saved" AND when i debug it...

I’ve done a search for solution to my XIRR issue within this board and the web and have not found anything that’s quite the same to help me solve this issue. Thanks in advance for any suggestions, and I will provide feedback on any proposed solutions. To get the answers I have, I modified...

Howdy, I have been running a number of processes at my company for years now (many were made possible from contributions from this community - thank you). I now have a new issue with files crashing Excel when loading into memory. The trouble is, it's not every file and its not every time. I...

Hey all, FormR kindly helped with combining two formulas together: =IF(AND(INDEX(T:T,MATCH(E5,AF:$AF,0))=G5,INDEX(BJ:BJ,MATCH(E5,AF:$AF,0))=H5),"Yes","No") This formula is replicated in Rows until 1500 i.e...

I've truck an oddball problem. My workbook opens ok, and to test I load my Form from the immediate window and close it If I then attempt close Excel. I get the wait cursor forever and need to Contrl-Alt-Del End task. Could someone in the know take a look at it please ? I have proved the issue...

Hi, My company moves us the Office 365 and I have developed an issue. I have a personal workbook that has several macros in it and when I open another excel file the personal workbook opens first the the selected one opens. The issue I would like to fix is when the requested file opens it...

Morning everyone. I've got a spreadsheet that has a data validation list where I don't want it to show blanks or duplicates, so use Power Query to set up a table that condenses the information and the data validation picks information from that table. The issue I've got is everyone in my...

Hi all, I just want to try the below request in VBA. Is it possible. > Filter blanks in the Column "Work" and update as "Issue" in column "Remarks" > I just wanna update as "Issue" based on the usedrange column A. Thank you.:biggrin:

Hi, I am looking at a document register system on Excel. I'd like sheet 1 to be the Index sheet. The Index sheet will look up the master "All forms and revisions list" and list all the forms with "Doc Ref numbers" beginning with "MF" and the most recent revision only. The master sheet with all...

Hi, Sheet2 Row/col A/col B 1/2017-01-01/closed 2/2016-01-01/open 3/2015-01-01/closed 4/2014-01-01/open Sheet1 If col B in sheet 2= "open", then return value in col A= 2016-01-01, and if today's date > than this date 2016-01-01= count. In this example I have 2x open items with dates back in...

Hi guys, I have a huge budget sheet that I use formulas to update data from queries rather than vba to update each cell (shaves a minute or two off the updates) Here's my issue. I need this sumifs to work on the page but the two criteria don't work together and they should. Separately they...

I have a userform which I open in workbook1, sometimes while the userform is open I need to access a different workbook. Problem Is when I try and enter data in workbook 2 I get Run-time Error '424' Object required" I do have worksheet calculate event in the userform, is this what is causing...

Hi, I am having issues performing my repetitive tasks using macros. I am new to it and would appreciate some help. I recorded a macro but when I try to run it, it starts working on the source file where I had recorded the steps rather than working on the target file. Also it keeps giving...

Hi all! Not really sure what supporting info to provide but I have a spreadsheet that has a rather odd behaviour. The workbook has a lot of formulae and a sheet that has over 7000 rows. That sheet has about 10 columns of formulae which include INDEX/MATCHES referring to a couple of tables in...