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

0
votes
0answers
11 views

Excel: Compare 2 tables and extract rows from both with a duplicate value

I have two sheets listing out customer name, date, invoice number and comments in columns. The data in both of these sheets are different and in a different order. How would I cross reference column A(...
0
votes
0answers
14 views

shifting a load of Electric Vehicle to the next row if a condition is not fulfulled in excel

I am making a scenario in excel where Electric vehicles are being charged in a given time range. i have a neighborhood loads and the load of EV at specific times. the cable capacity is 50 kW (means ...
0
votes
1answer
19 views

“=SUMIF” Formula not working with 00/:00 formatting

Good Morning,I have a spreadsheet I am working on and need to have the total time spent at a location automatically be calculated depending on the start and end time. It works if I keep the ...
0
votes
1answer
8 views

Split data into new column

As per attachment i have column A having name with underscore "_' and bracket " [ " . I need a formula to get answer of column B means I need formula to get id before underscore and inside bracket ....
0
votes
0answers
15 views

Matching Random time entries with a time seires

i was previously facing a problem in generating random time values when the time crosses midnight e.g. 11pm to 5 am but it was solved with the help of one user here. trick was to add 1 to the formula ...
0
votes
0answers
25 views

How do I count the result of a selection from a VLOOKUP and add the next sequential number to each one?

I have a spreadsheet for actions (Corrective, NCR, IMP, etc.), and need to have it automatically count the types of actions raised to create individual action numbers. I have used VLOOKUP to be the ...
0
votes
1answer
22 views

Excel SUM() Formula Not Working

I have a complex formula: two SUMIFS formula nested in a SUM formula. The concept is to sum amounts given a specific time period and specific account code.This formula seems to work great. I get an ...
0
votes
2answers
33 views

Is there a way to use excel's VLOOKUP with multiple criteria?

I'm attempting to create an aggregate of data that looks at a list with a lot of duplication of items and compiles a total number that the duplication appears, and a unique value associated with the ...
0
votes
0answers
21 views

Vlookup issue | Macro Heavy Worksheet

Hey I am having quite a weird issue with a file a built that is very macro dependent. It centers around a simple vlookupCurrently my macro creates a line item on one sheet (Sheet A), then copies ...
0
votes
3answers
32 views

Better Excel shortcut for current time

Is there a way I can set an easier shortcut for the current time in Excel? I know about "ctrl+shift+;" but I need something that can be used with one hand. Ideally if I could set up and F key to add ...
0
votes
1answer
27 views

Auto Calculate Hours for Shift

Good Morning,I am using Excel and have am trying to be able to add a punch in and out time, then have the total time between those automatically be calculated in the next spot.This works when I do ...
0
votes
0answers
36 views

Generating random time values in Excel [duplicate]

i am having a problem with Random time generation within a given time limit in excel. problem is if i give a time range from morning to evening the formula works great but if i give the time range ...
1
vote
1answer
45 views

Change a function used in a formula, using the function name stored as text in a separate cell

I have this formula=ROUNDUP(D12/(D6-D5),IFERROR(VLOOKUP(G9,reference!$C$2:$D$7,2,0),100))and I want to change the ROUNDUP portion based on text from a separate cell (say, F7, where the text can be ...
0
votes
1answer
56 views

VBA code for subtraction of subsequent numbers in a list from the first value

I have a list of numbers. I want to use the first number in the list as a starting value and subtract the subsequent numbers from it, using VBA.I have made several unsuccessful attempts:Function ...
0
votes
2answers
47 views

Excel freezes when running macro

Private Sub Worksheet_Change(ByVal Target As Range)Dim KeyCells As RangeDim i As IntegerSet KeyCells=Range("H4:H100")If Not Application.Intersect(KeyCells, Range(Target.Address)...
0
votes
2answers
39 views

Count specific items separately in 1 cell

I need a formula like COUNTIF for this problem.Forexample:I write ''a, b, c, d, d'' in 1 cell, but want them to be counted separately like this:a -> 1b -> 1c -> 1d -> 2I tried with ...
0
votes
1answer
13 views

Keeping hyperlinks functional after moving directory

I currently have a worksheet in which I have several hyperlinks to folders. I am attempting to have the hyperlinks automatically change when the root path changes.I have figured out how to have a ...
0
votes
2answers
18 views

Lookup Function Giving Inconsistent Results in Excel & Google Spreadsheet

I am trying to create a column of looked-up values using the LOOKUP function. The goal is for the formula to look up the "rank" value of each "name" and print it in the "lookup" cell on the same row. ...
1
vote
1answer
41 views

Formula to SUM values in mulitple columns, based on criteria from another column

I have a sheet with three columns. The first is called "Account Number" (AccNr). The two other contains values related to each account number. It looks like this:AccNr. | Value 1 | Value 21000 ...
0
votes
0answers
15 views

Calculate multiple worksheets using index match sum

I have a formula that works=INDEX('[Test.xlsx]Report 1'!F:F,MATCH(B8,'[Test.xlsx]Report 1'!A:A,0))This will being me back the value 37; in report 1.-report 1 is a worksheet, and there is 6 in ...
0
votes
1answer
17 views

Index match finding the first value only

I have a list of employees with duplicates and each employee has a number which represents the number of sales. I'm trying to use the following formula to extract the highest sale for a given name, ...
0
votes
1answer
88 views

Identify first login and last logout entries

I have a spreadsheet that needs to determine the first time a user logged in to the system and the last time the user logged out.The login and logout report comes from another system from which I ...
0
votes
1answer
30 views

Auto-populate one table from another table if a criteria is met

I have two tables: Information and List.The Information table has two columns: Name and Gender.The List table also has two columns: Male and Female.I'm trying to auto-populate the List table ...
0
votes
1answer
18 views

Excel - How to HIGHLIGHT entire row with specific NUMBER value match, (this specific value is output result from another conditional formula)

Excel - How to HIGHLIGHT entire row with specific NUMBER value match, (this specific value is output result from another conditional formula) With this attached excel screen shot "J" and "K" showing ...
0
votes
1answer
46 views

Sum Function with Index/Match Function

I have to prepare summary sheet for the expenses, claimed by employees.What I need from this summary:Different expenses claimed by employees month-on-month. I've a sheet named as 'Dataentry' ...
0
votes
0answers
9 views

Array Formula Auto-Calculation in Google Forms [migrated]

I have a google form which is returning data into Column A and Column B and I need to perform calculations on that in Column C,D & E. I have been using Array Formula so that C & D auto-...
0
votes
0answers
17 views

Google Sheets: replace formula with its value after evaluation [migrated]

In Google Sheets, I'd like to replace a formula with its evaluated value immediately after evaluation. Specifically, given two empty cells A1 and B1, I'd like B1 to be filled with the timestamp of ...
0
votes
0answers
31 views

How to generate rows by linking to a number in a cell in excel [on hold]

Can you generate a number of rows by linking the amount of rows generated to a number in a cell in excel? for example each column has calculations, if I would like to generate 60 rows of calculations ...
1
vote
1answer
47 views

how to grab data if value=yes

So I have a worksheet that has 2 columnscolumn A(name) Column B(Yes/No) Column cName1) YES Name1Name2 NO Name3Name3 YES ...