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

learn more…| top users | synonyms (5)

1
vote
0answers
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
0answers
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
0answers
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
1answer
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
2answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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 ...

153050per page