kind

Hi guys, I'm a relatively basic excel user, and now I'm faced with an issue that I'm sure it's fairly simple to resolve, I just can't figure it out. I have this spreadsheet where I'm given just the name of the passengers, how many days they'll stay and which kind of room they'll use. Also, I'm...

Dear All, I am wondering if it's possible to generate a formula that will give me the following desired result: <tbody> <tbody> A 16 A X C 7 B X B 3 C Z </tbody><colgroup><col span="6"></colgroup> Is it possible to get the answer 23 (16+7) with some kind of SUMIF formula for...

Hi I need to extract the text from inside the " " Example: 1^/CLIN["KATHERINE"], <tbody> 1^/CLIN["PETER"], </tbody><colgroup><col></colgroup> Can you help please? Kind Regards Katherine

In Notepad++, the Save button is "greyed-out" if there are "no changes" or the file has been "saved". This is kind of useful. Is it possible to do this in Excel 2010 somehow?

Hi all I'm trying to work out if it's possible to calculate whether or not a given week contains the last Friday and if so place some kind of marker to flag this up so that I can determine which reporting month it should be in. Any help appreciated! W/C 01/01/2018 08/01/2018 15/01/2018...

I am new to Excel and I'm trying to write a formula that will change the value of a set of numbers to a different value. i.e. 116 ~161~ 161 i.e. 225~ 552~525~ 520 for numbers 1 thru 0. Would some kind soul Help me. I have started writing with the Subsitute function however I'm not advanced...

I personally never used this program before in my life. So if anybody can be so kind to summarize what the purpose of this program is for, I'd really appreciate it. Thanks in advance

Hi all, Please help me about this situtation. Now, I have much orders which are have some kind of goods is the same. It's on the data_need_find sheet. The inventory have the total data = data_source sheet. And the question is, how I could make a macro to minus decesing the quantity of each kind...

Hi I actually need help on both of these. I just need to return blank if nothing is found. Right now it returns 0 if nothing is found and is kind of annoying thanks =' Rates Table'!A68 =IFERROR(VLOOKUP($A$6:$A$208,' Rates Table'!$A$1:$D$506,4,0),"")

Hey guys, I am able to click an optionButton in IE with vba code : Set optionButtonBizRules = IEDoc.all optionButtonBizRules.Item("radio_bizRules")(0).Checked = True The only problem is that I physically need to click on the option button in the IE browser to be able to have access on...

Dear all, Can you please help me with the following: I would like to highlight the CELL in COLUMN C if the corresponding CELL in COLUMN D is empty. Kindly advise. Kind regards, Opgelost

I have a document with 250k or more rows. Each row is representing specific event. Screenshot of document is below: Is it possible to develop formula which will do the following: my input: text of field H (i would like to vary this one within the formula) Output: dates, and number of...

Hello, I would like to make a shareable workbook that will only allow cells to be colored in or checked off, is this possibly, kind of like a checklist. I don't want anything else changeable. Thank you for your help

Hi, I have two columns of data, one of which is the primary source but contains some #N/A's. For those rows I want to take the data from the secondary source. I know how to create a conditional column and can use the wizard to check for certain values, or even nulls, but I don't know how to...

Hi MrExcel, I am currently working on a mini-experiment which is like an internet browser. I have a list of websites which are on a ListBox, every time a specific website is listed, the WebBrowser will navigate to the corresponding website which is selected from the ListBox. I would like to...

Hi All, not sure this is the right place but...I have a bunch of very old email addresses that I have entered into a data base for a local non-profit. Most of the emails are probably bad but I can't tell. I have Gmail and or Yahoo but neither of them have any kind of feed back to let me know if...

Hi hope someone can help I am trying to open AutoCad LT from excel but not having much luck. anyone kind enough to give me a hand? thanks