helpful

Hi, So the title of this thread is probably not the most helpful but I could not come up with anything better - suggestions are welcome. I have a formula like this: =IF(SUM(E9+H9+K9<=8),8,SUM(E9+H9+K9)) which basically says if the sum of the values in cells E9, H9 and K9 are less than 8 then...

Does anyone have a suggestion on how I could create a situation where clicking on a particular word in a cell initiates a Find for that word? I have a list of customers and it would be helpful to be able to click on a particular customer and then see all the other locations in my workbook that...

Where's the book, folks? You are all generous and very, very helpful. I'll buy the first copy!

Can they be turned OFF in VBA ? So it saves a User figuring it out and only affects *this" workbook. Thanks for any help. I googled for this and found I'd asked the same thing here back in 2009 but got a not helpful reply. It would be helpful to know if they can't, and I can stop looking.

Hi, I've created a helpful Hyperlink+VLookUp formula that could really benefit from a small addition. But I just can't seem to figure out a solution. Here's my formula: =HYPERLINK(VLOOKUP(A1,Tab2!$A$1:$B$52,2,1),"Name") Basically, it returns a webpage stored another sheet that matches a...

This is only my 2nd post, but the 1st one was so helpful, I'm going back to the well. I have a formula that isn't working the way I think it should: =SUM(SUMIFS(c2:c9,b2:b9,{">=6037","<=6332",4010},a2:a9,{100,101,134,136,141,355,357})) ---- How can I fix this...

Hello all, Hoping you can provide some help to a monthly task... I have a table with a list of individuals with a last date of attendance in one column followed by the 12 months. I have provided an example below: <tbody> Name Actual Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct X1...

Hi Guys, this is my first post and I have always found this forum helpful for my excel queries, I need to know if there is any possibility to connect my excel pivot with Googlesheet?

Hi all, I need to name all the cells of a column ("A" column) of a sheet with the cell value. I mean, if the cell says "Mister", the name would be "Mister" as well. I know to do it manually, but I think that a macro for this will be very helpful and not too hard to make, but I don´t know how...

Is there a rational reason why the board requires that I wait 3 seconds between clicking on Like this post and Thank you for posting this? For that matter, is there a rational reason why there are two ways to acknowledge a helpful post?

Hi guys, I need a simple VBA code that will open a new email in outlook and with the TO and CC recipients predefined and the subject line prefilled. Pretty much a newbie to VBA so any help resources for beginners you find useful would be helpful too. Thanks in advance.

Hello all - I would be very grateful for any help with the following: A very helpful board member, jtakw, helped put together the following...

Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet. There is also data that is the same across spreadsheets that it would be...

Hi everyone. I need some help creating a spreadsheet to calculate revenue from different businesses, and I want to keep all the data separate. But, I also want the data to interact with each other on one master sheet. There is also data that is the same across spreadsheets that it would be...

Hi All, I know this is simple but It would be helpful for me to freeze A specific Column in the spreadsheet or Freeze more than 5 Column in spreadsheet..:rofl:

Hi all, Could anyone please remind me of how I can select my current line / fill to the right only to the end of the line above? I.e. I have figures in the line above the blank line I'm currently in and I'd like to copy a formula all the way across to the right. But not as far as the whole...