easier

Hello all, I want to use indirect formula to look up certain range in different sheets, is there a way to extract the sheet's name to use in the formula? it maybe easier than I thought but I haven't found any way to do that, thank you

I thought I would put my question in the subject line to make it easier to answer. I have large Market Cap numbers such as 2,500,000,000 and I would like them to be easier to read. So 2,500,000,000 could look like 2.5B or 2,500M something like that. I am sure there is a simple formula for this...

Hi, I want to make a lot of cells mandTORY, iS THERE AN EASIER WAY TO DO THIS RATHER THAN THIS CODE: After this can put no more code in as it says too many line continuations If Application.Sheets("WERS ALERT SHEET V14").Range("C5").Value = "" Or _ Application.Sheets("WERS ALERT SHEET...

It is getting where I have so many tabs on the bottom of my spreadsheet that they are kind of hard to find. I am using excel 2016. Is it possible to place a second row of tabs on top of the existing row to make them easier to see, or perhaps any other creative ideas instead of having to create a...

I have a lot of different sections that need to be conditionally formatted for instance I have a lot of different rows that need to be formatted depending on what is in row 2 However, when you go to edit in the box it looks like this...

Hello. Please, I need to know any safe website, where I can upload in easy steps my workbook, so in that way when I post a question here will be easier for you guys, just click the link. Thank you for reading this.

I have four columns and five rows.....I have a formula that works, but there must be an easier way this is what I'm using,maybe it can be condensed. I might want to expand the formula to accommodate more columns, but for now...

I know there is any easier way of doing this by combing if(and(or statements, but I did it the long way. How can I combine all of these IF Statements to 1 formula? IF((AND($A41=1,$B41=0,$C41=0,$D41=0,$F41=0,$G41=0,$H41=0,$I41=0,$J41=0)),"Step 1","")...

Hi Im wanting a macro to paste whatever is in the windows clipboard into a sheet Do i need to use DataObj or is there an easier way? Like replicate ctrl-v being pressed Any help appreciated

Hi Everyone, I'm looking for a way to create a Date (dd/mm/yy hh:mm:ss) from two cells A2 = "24/01/2018 00:00:00" and A3 = 12.00 (this can be changed to another formate if easier but a number is likely how can I combine the two to get ""24/01/2018 12:00:00" but actually as a date not just...

Hello everyone, Been working on an automated bidding spreadsheet to put on a tablet for quoting projects... since 2012 haha. You guys have been indispensable and I just started working back on it again for the first time in a year so use your kids gloves with me please. I've forgotten...

I have a large workbook with 50+ worksheets of physician names that I want to put in alphabetical order to make it easier to find each tab as needed. Is there a way to do that beyond manually dragging the tabs? Thank you!

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi, Application.Goto Reference:="R3C14" Instead of using R3C14 in a macro, is the a way to cell reference, like N3 It would be easier for me :) Mike...

Hi All I'm trying to make a formula dynamic but not having much success What I'm trying to do is count how many unique entries there are in a column (text and numbers) I'm using: ="Installers Using App " & SUM(IF(FREQUENCY(MATCH(G2:G194,G2:G194,0),MATCH(G2:G194,G2:G194,0))>0,1)) and this is...

Hey There, I am currently using a lot of sumproduct formulas in my sheet and was wondering if there is an easier way. Every time I add someone to the page (which takes forever between all the calculations, I have to go through everything and copy-paste and change the name so that the formula...

Hello I am trying to automatically default some cells to a minus figure. I have seen you could do an ABS formula but wondered if there was an easier way? I only want to do some cells in the column as the others are positive figures. Thanks

hi good people, I amsearching but appear to only find help with text in different columns...I have numbers in 5 non-adjacent columns and need a unique list..please can someone assist with a formula, or maybe an easier route which would be VBA?..columns are: E, H, L, P and S..thank you all very...

Hi, I have made an excel file where i want to do a few sensitivity analysis. To remain flexible, i have put a formula on the data that the what if analysis tool has to take for its calculations. https://imagebin.ca/v/3irbzK2IVH6D Like putting on a row -5% to +5% compared to my basic assumption...

Is it possible to calculate how many weeks are in the current quarter? For example, if A1= 4, then B2=13. I was thinking there was an easier way then counting how many weeks each quarter. Thank you in advance for your help!

Good morning I tried few of the suggestions from google but still can't get it done right. I need to find the value from corresponding date & time. Here is a pic for easier understanding - Im trying to fill all the cells in column G with the corresponding data from column C The first example...