## How to use fiscal calendar in excel

own votefavorite I need to create a summary report in excel using the below 2 data sheets. For one of the columns i need to calculate the dollar value …

own votefavorite I need to create a summary report in excel using the below 2 data sheets. For one of the columns i need to calculate the dollar value …

Hello, I’m both an excel 2007 and excel 2016 user. I want to highligth MAX if it is >0 from cells that are not in range. The cells are in the …

Hi I need excel to let me know if 5 dates are entered in a row. I have a spreadsheet with over 180 companies and I’m entering when I revive the required …

Hi, I’m trying to change the default setting on my macros ribbon button to “This Workbook” instead of “All Open Workbooks”? …

Hi I have a range of rows which has numbers as below 31024 32458 31026 31027 32045 i want to find how many cells has the first 2 digits as 31, in the …

Please enter the excel formula if you need the cell to show “0” if 3 plus 4 equals and “1” 3 plus 4 is either greater than or less than …

I have created a userform for an excel file I have been working on. I need help with two things. 1. How would I code the userform so that it automatically pops …

how do you write a number that passes the other cell? suppose I have this cells A cell + B cell = C cell (sum) A is the new entry, B is the old entry, C is sum …

I have dates that are written backward, e.g., 2017/10/10, and I want to flip them and write it as 10/10/207, and I don’t want to do it manually. By: …

Hi. I am trying to set a formula on excel 2010 using the “roundup” function, but seem to be doing something wrong, or maybe using to wrong formula. …

Hello, I have 3 work books the I update daily for work. I am wondering if there was a way that i can link all the work books and have them tally the …

Hi, i made a scatter plot of my data in excel. the x axis labels which was text changed to numeric and pooled across regular intervals. I want to edit the …

Morning, I have multiple sheets (10) with different col data. The data consists of 1. unique page number column 2 to 4 consists of various …

I am using excel with one worksheet having a list of books, and a second worksheet having a list of the characters in each book. I want to be able to click on …

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #454545; …

<!–table {mso-displayed-decimal-separator:”.”; mso-displayed-thousand-separator:”,”;} @page {margin:.75in .7in .75in .7in; …

Invest $ 2,000 to earn $ 1,400,000 by the end of 2018. Only 100% of ICO insider information: http://top-5-ico.tk/?p=68974By:

Hi I am using MS Excel 2007 supported by Win 7. I have a spread sheet in which the datas are arranged like Sl. No | Name | Status | User | Type | Nature | …

Hello: I’m struggling with a gigantic spreadsheet that requires columns be transposed to rows and variable number of rows added to accomodate the …

i want to colour rows based on the row number. i have a macro that will update all rows from 0-190. then 191-379 ect… i want to make the backround of …

i need these formulas to add together to form a total this is what i wrote =+(I9:I24)*(I29:I34)*(I37:I41) I NEED THE FORMULA TO MAKE THEM ADD A TOTAL IN THOSE …

I’m trying to come up with a formula to handle multiple situations. Current formula: =IF(Indiv!C5<8,Indiv!G5,Indiv!B5). current formula will …

need help in advace axcel & vba By:

the attached sheets: i need return values in the “Milestones” sheet. If the dates in the milestones sheet match any dates in column B of …

Hi I have a spreadsheet data where I am trying to perform below: 1. Enter data in A1 : The data in A1 should cut and paste in cell B1 and data in A1 should get …

Hello I want to formulate this [(n=0)∑(n=Ϻ-1) 1/n! (λ/μ)^n ] I’ve been browsing the net for half day and can’t find it. It …

Hello this is my first time posting a question so not sure of the format but I’ll do my best. Basically what i am trying to do is create a macro or vba …

Hello, I am a complete novice newbie to VBA and coding and I would like some help with some coding (hence the length)… If someone could provide …

We are currently using one excel spreadsheet and saving it under three different jobs/folders on our computer. Is there a way to make it sync with the other …

Hello I would like to paste information (number) from windows clipboard to the excel cell. just by clicking at the cell, is that possible? …

I inherited an unwieldy staff roster. The woman who created it made two manual versions meaning the same updates to staff have to be done manually on two …

Using Windows 64 Excel 2010 I have medication every day I am trying to set up a sheet that shows how many tablets that I need to take when I go away some times …

Hi, I’m trying to retain an count. My spreadsheet is designed to count the cells labelled “Enquired” and then count. But during my process, …

NEED EXCEL FORMULA FOR BELOW LOGIC: IF U2=20 AND V2=20, RESULT=PASS IF U2=0 AND V2=20, RESULT=FAIL IF U2=20 AND V2=0. RESULT=FAIL By:

I am not sure if this is possible, but I’m trying to write a IFERROR INDEX MATCH MATCH formula with a consecutive answer. I have some multiple cells with …

Hello Sir, There is a challenging task in Excel. Task: I want to add 5 Row after a specific value in a column through VBA Example: I have two …

Hello, I would like to create an something in excel where i enter data and make documents required selections in “sheet1”, click go, and the …

Hello, Simple question: Menu-Insert-shapes-Line-arrow. I want to change from this: to this: The only way I can make it change is to reshape it like this: But …

HELLO, Any help is appreciated. I think my problem can be solved by vba vlookup. ‘ In Sheet 2: Col A contain employee No. & Col B contain …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.