Questions about using in-cell functions/formulas in spreadsheet software.

**1**

vote

**0**answers

10 views

### Can Excel automatically convert an entry into a clickable link inside the same workbook?

Please let me better clarify my question. What I would like to do is the following:1) Have a workbook with, say, 100 worksheets2) Each worksheet has a different tab name3) Each worksheet ...

**-1**

votes

**0**answers

18 views

### Duplicate sheets while retaining and updating incremental formatting in cells

Last year I built and formatted 52 tabs (sheets) names 'Wk1, Return1''Wk2, Return2' both up to wk52 and Return52. There is a lot of formatting in individual cells within these sheets. Wk2 takes data ...

**0**

votes

**0**answers

13 views

### How to add an existing Excel userform & VBA to new spreadsheet (For Dummies)

I have an end user who exports data from an accounting program and each time they export and create a new spreadsheet, they need to add a userform and VBA file. Below are the instructions I have ...

**-3**

votes

**1**answer

31 views

### Limits of creating a database with Excell [on hold]

I'm creating a in-house database to track the progression of multiples files. An Excel sheet should be enough for our current needs, but I have three quesitons regarding Excel limits:is it possible ...

**1**

vote

**2**answers

20 views

### Excel how to deactivate “Most Recently used function” suggestion from drop down list

I am currently using Office 365 on Mac.For the "Drop-down Function-suggestion list", Excel have started suggesting the "most recently used" function, as opposed to JUST suggesting it in alphabetical ...

**-1**

votes

**0**answers

30 views

### I need to calculate all the extra working hours in a month in excel

Hello I need to calculate the extra working hours of a month but there is a twist:spreadsheetIn the first row we have the dates of the month (01=01/01/2018, 02=02/01/2018) in dd/mm/yyy format. ...

**0**

votes

**1**answer

29 views

### Excel: Data across multiple columns and rows

Currently have a table like this:How can I consolidate and count the hours per person spent on each day. Need to be on seperate lines due to working on different tasks but want to bring in all ...

**-2**

votes

**0**answers

17 views

### how to Return a sum value using multiple conditions in two or more columns [on hold]

I am trying to find a formula to resolve the following:Column A has three criteria and Column B has five criteria. I would like to have the summed value in column C for each criteria in Column A ...

**0**

votes

**1**answer

17 views

### Excel - How to subtract cells and add columns

So lets say I have 2 columns, A e B, like for example:A B C -----------------------------1 | | A | B |-----------------------------2 | ...

**1**

vote

**1**answer

21 views

### Need a Formula to add the current date in a specific cell that data is added to another

I have a spreadsheet that has to have data entered into it each and every dayWhat i would like is that when Data is entered into lets say A1 that the current date is put in G1. And every day when ...

**-1**

votes

**0**answers

26 views

### SUMIFS function to reuse data from the same criteria in EXCEL

I'm trying to make a dynamic cash flow for my budget calculation.I already did my normal "IN/OUT" since they don't have any dynamic cells.However, I'm stuck in the Loan criteria because i'm using ...

**0**

votes

**0**answers

14 views

### MS Excel SUMIFS with filtering criteria

I have a table "Balance sheet" likeA B C D E F2 REVENUE | $100.94 | | Starting Date | End Date | Category3 | ...

**0**

votes

**0**answers

10 views

### How to use dynamic file names in Excel?

I have a set of workbooks set up for work where there are multiple, identical sheets reporting key metrics back to a supervisor's workbook. To improve efficiency and lessen my workload when new ...

**2**

votes

**1**answer

33 views

### Counting cells that contain=

I am trying to count cells that contain the=sign. I have done this many times before but for some reason this time it is counting the blanks and none of the=signs. The formula used is=COUNTIF($...

**0**

votes

**0**answers

10 views

### MS Excel perform Sumif and filter criteria

In cell H1 I want to sum D:D only if values are >0=SUMIF(D:D,">=0", but I also want to consider filtering which only works by using=SUBTOTAL(9,D:D), the problem is that I want both, how can I ...