short

Hi I want to Right click on group of cells --> Format Cell --> Custom --> [h]:mm So it is 3-4 click and I want to do that alot. Can I create a short cut to do these 3-4 steps in one click for example. Or Can I create a link in QAT area. Thank you very much.

How to write a VBA code to get the below output. If Column A = Internal, Then column F = ok and If Column C = Long or Short Then column F = ok and if Column A is anything else, then it should check if Column C = Long or Short if yes then column F = ok else column F = check. Thank you in...

Hello All, I cant remember.... Isn't there a way to move a column with formulas over to the left of another column without your formulas changing? I know this is a basic short cut....But am having trouble remembering it...

Morning, Been trying to convert a MATCH INDEX result from date number to short date. The formula I have so far which does not quite work ="ENQUIRY"&-INDEX(B3:B17,MATCH($A$1,A3:A17,0))

Hello, I have a question. I would like to calculated ratio's from a database with balancesheets in a pivot-table. The data is as follows: <tbody> Company Balance Sheet no Description Value Year Apple 3 Cash 25 2018 Apple 4 Inventories 35 2018 Apple 5 Short Term debt 75 2018 Facebook 3...

Hi All, I have a spreadsheet with 2 macros and 2 sheets within the workbook (sheet 1 and sheet 2). I am very junior with VBA so apologies in advance. I have the below in which I am receiving this run-time error and the "If Range("D2").Offset(num - 1, 0).Value > 0 Then" row is highlighted...

Hi guys, I made this command, before it was working fine. I have been using it for quite sometime now. Sheets("DATABASE").Rows("4:1048576").Delete Now suddenly there is an error showing, I didn't change anything to my programming. Error 400. Tried this too in hope that it will get fixed...

Hi What is the short cut of excel speak command. Many websites (like the one below) list excel short cut but none talking about speak cells. Any idea would be appreciated very much. https://yodalearning.com/tutorials/ms-excel-shortcut-keys-for-beginner/

Hello, I am wondering if anyone may be able to assist me in creating a VBA macro. What I am looking to do with the below is sum up the "Long Total" column, but only where the "Long Curr" column shows USD. Anything else I need the long total column to be zeroed out. The last piece is I need...

Hi, I have a formula like this =IF(OR(COUNTIF(A1,"*"&"ABC"&"*"),COUNTIF(A1,"*"&"DEF"&"*"),COUNTIF(A1,"*"&"GHI"&"*"),COUNTIF(A1,"*"&"JKL"&"*"),COUNTIF(A1,"*"&"MNO"&"*"),"IMPORT","LOCAL") Is there a way to just put all wildcards condition in a column to make to formula shorter? I have a total...

hi all, kindly anybody tell me short cut to find out desired output if possible. i have a record on station wise separate sheet. 50 sheets station wise. i apply: =VLOOKUP(F2,A2:D7,3,0)+VLOOKUP(F2,Sheet2!A2:D7,3,0)+++++ this is too lengthy. is there any short cut to find Vlookup countif, SUMIF...

Dear all, I have a table (I have added a table with pictorial values) with quite a bit of data, under there is another table divided by countries with INDEX and MATCH, as you can see not every country has values, I would like to have only non-empty countries in the list. According to the...

I am trying to use the same priciple behind sumproduct since I have a lot of moving variables in my table and reference that need to be matched. I have the sum products working fine (see example) because they are actually finding sums. I need to do an average of the CM/ST and CM/MT since there...

Hi I think this might be a quick question for someone.... I have a line in my code to input the date from a cell into a date picker IE.document.getElementById("startDatePicker").Value = Selection.Offset(0, 11).Value The cell is formatted to Short Date. For example 10/01/2018.. but when it is...

Hi I was reading the article below and the author said using Alt+= to activate the subtotal function? Why subtotal function has short key? do other functions have short cut keys? thank you. https://yodalearning.com/tutorials/subtotal-excel-formula-excel-advanced-filter-trick/

I tried to write an explanation of what I'm trying to accomplish in Excel, but can't find a way to explain it clearly, so I recorded a short screen video of my example sheet with explanation. I'd appreciate any help. Here's the explanation/question video link. Thank you!

The following measure produces a different result depending on whether I use a machine with Excel 2013 or Excel 2016: =FIRSTNONBLANK(Russell_Group[Provider short name], IF( [Research Income (Total) £k] = CALCULATE([Benchmark (Research Income £k)], VALUES(...

Hi, I have an Excel report, 7 Tabs, 1 for each day of the week. 4 Separate sites fill out this report each morning. All shortages are entered into the table, whichever site opens the report first, second, 3rd or 4th (This will vary from day to day) File is not shared I purposely refrained...

I Have this File with Short Note inside https://www.dropbox.com/s/kq424sszpd7gu6e/Draw.xlsm?dl=0 Hope that is enough info..

I would like to enter a column in a table where the data should look like a year and a quarter end. For example, I would like to see 2018 Q1 or 2018 Q2...etc. Or I am okay with using actual months but then it must only be quarter end dates (3, 6, 9, 12). 1) Is it best to use a date/time or...