Trending questions in Others

0 votes
1 answer

Excel Vlookup function to map duplicate and get the max occurence value

Assuming there is no Excel version restriction ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,720 points
364 views
0 votes
0 answers

React useEffect Hooks with setTimeout

I am so confused here with React ...READ MORE

Jan 27, 2023 in Others by Tejashwini
• 3,820 points
713 views
0 votes
1 answer

Insert multiple columns to the right in sequential order

Duplicate Columns Why these complications? Flexibility. You don't have ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,720 points
341 views
0 votes
1 answer

How can I add a wildcard to my if formula (that also contains an or condition)

3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
417 views
0 votes
1 answer

Successive retrieval of defined ranges, by splitting thier names in a constant as well as a dynamic part

You can use a Select Case statement : Option Explicit Sub ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 63,720 points
279 views
0 votes
1 answer

How to return the last n number of values corresponding to a specific category?

Try: The formula in F3: =TAKE(SORT(FILTER(A:C,B:B=F1),1),- ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 63,720 points
274 views
0 votes
1 answer

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
• 63,720 points
1,183 views
0 votes
1 answer

VBA code help - Add a line for each missing date with the start and end date defined in a cell

Try this: Sub FillDates() Dim ...READ MORE

Jan 24, 2023 in Others by narikkadan
• 63,720 points
793 views
0 votes
1 answer

Select a range in Excel based on the value of a cell

Try this: Dim WorkRng As Range Set WorkRng = ...READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,720 points
568 views
0 votes
1 answer

Excel links keep crashing

When the links in the master sheet ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,720 points
518 views
0 votes
1 answer

Formula to count if a text is written in a cell

Use SCAN, like this: =ArrayFormula(IF(A1:A10="",,SCAN(-1,A1:A10,LA ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,720 points
300 views
0 votes
1 answer

How can this code be modified to increase the number of months instead of days?

You have to use dateadd. For i = 1 ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 63,720 points
338 views
0 votes
1 answer

VBA reordering columns from different workbook or sheet

Try this: Sub OrderColumns() Dim ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,720 points
294 views
0 votes
1 answer

Autofill macro to autofill dates up to 31 days regardless of the month

If you wish to utilise a single ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 63,720 points
248 views
0 votes
1 answer

Compare each excel sheets with a table in oracle

One way to verify the count and ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 63,720 points
246 views
0 votes
1 answer

How to remove data within a multi-line cell that comes after a few line breaks

find() return the starting position of a ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 63,720 points
675 views
0 votes
1 answer

Converting Textboxes Link and/or Formula to Values in a Copied Sheet using Excel VBA

Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,720 points
459 views
0 votes
1 answer

Turning a .xlsx into multiple PDFs

You just need to adjust the font ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,720 points
452 views
+1 vote
1 answer

ng is not recognized as an internal or external command

I solved this problem in accordance with ...READ MORE

Feb 11, 2022 in Others by Rahul
• 9,680 points
15,662 views
0 votes
1 answer

Differences between git pull origin master & git pull origin/master

To answer your question, the git pull ...READ MORE

Feb 11, 2022 in Others by Rahul
• 9,680 points
15,701 views
0 votes
1 answer

How can I allow a user to change a cell in excel only under particular conditions?

Copy the next event code in the ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,720 points
430 views
0 votes
1 answer

Excel VBA - Subscript Out of Range Error (Run Time: Error 9)

Set rangePartner = Range(Partner.Cells(2, 2), Partner.Cells(2, 2).End(xlDown)) Needs ...READ MORE

Jan 21, 2023 in Others by narikkadan
• 63,720 points
857 views
0 votes
1 answer

What is the shortest formula in excel to covert text date format e.g. 17 Jan, 2023 into regular date format like 1/17/2023?

The SUBSTITUTE() method can be used to ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,720 points
460 views
0 votes
1 answer

Project ID printed for every task on the API problem

Try this: def teste(id): listID = ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
323 views
0 votes
1 answer

Excel file download using java - Error : File is corrupted

Try this: @GetMapping("/downloadDOA") public ...READ MORE

Dec 28, 2022 in Others by narikkadan
• 63,720 points
1,881 views
0 votes
1 answer

Excel - How do I make rows that contain row headers into two columns

You can use this formula: =LET(values,B1:E2, headers,MAP(values,LAMBDA(v,INDEX(A1:A2,ROW(v)))), HSTACK(TOCOL(headers),TOCOL(values))) Via MAP the row headers ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 63,720 points
617 views
0 votes
1 answer

Defining last nine rows of data as range to copy values and transpose paste into another worksheet

Transpose Last Rows Sub PrintLastRowsAddress() ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,720 points
393 views
0 votes
1 answer

Export ListBox Data to Sheet range

Use ListCount to retrieve the number of ...READ MORE

Jan 12, 2023 in Others by narikkadan
• 63,720 points
1,209 views
0 votes
1 answer

Compare 2 columns in same excel sheet in pandas

Try this: import pandas as pd import numpy as ...READ MORE

Dec 16, 2022 in Others by narikkadan
• 63,720 points
2,371 views
0 votes
1 answer

Find value in column where running total is equal to a certain percentage

VBA bubble sort - no changes to ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 63,720 points
246 views
0 votes
1 answer

Unable to load 'minutes' correctly from CSV into in Power Query / Pivot

Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 63,720 points
242 views
0 votes
1 answer

How to gentrate Unique Id in ReactJs

You can use useId to create a ...READ MORE

Feb 8, 2023 in Others by Damonlang
• 1,230 points
259 views
0 votes
1 answer

Excel - return a value only if a condition is met via VBA

You could use IIf() DestSheet.Cells(erow, 9).Value = IIf(newuplift = ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 63,720 points
581 views
0 votes
1 answer

Divide a range of values for each unique value

With the next available row as the ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
276 views
0 votes
0 answers

Calendar React JS

I have a homework to make a ...READ MORE

Jan 27, 2023 in Others by Tejashwini
• 3,820 points
557 views
0 votes
1 answer

Datedif issue - convert number of days to "--Years--Months--Days" format

Try, =DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,720 points
403 views
0 votes
1 answer

Find max and second max salary for a employee table MySQL

SELECT MAX(SALARY) FROM Employee WHERE SALARY < ...READ MORE

Nov 7, 2022 in Others by gaurav
• 23,260 points
4,066 views
0 votes
1 answer

How to get the total of every monday to saturday or tuesday to sunday in a month dynamically

Try this: Option Explicit Sub demo() ...READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,720 points
439 views
0 votes
1 answer

Copy the time to the next row of another column

Try this: Sub CopyCurrentTime() Dim currentRow As Integer currentRow = ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,720 points
391 views
0 votes
1 answer

Excel formula to calculate MIN in table filtered

Try this: =SUBTOTAL(105;B2:B7) READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,720 points
383 views
0 votes
1 answer

Extracting info from hyperlink

This will offer you an example of ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
240 views
0 votes
1 answer

Want to create a chronological row # then reset based on font color

Use this function to test the font ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
236 views
0 votes
1 answer

Get Code Isin from Bloomberg with Excel formula

In answer to the follow-up, BQL is ...READ MORE

Oct 29, 2022 in Others by narikkadan
• 63,720 points
4,384 views
0 votes
1 answer

Calculating accuracy within excel

Format the cell in Col C as ...READ MORE

Dec 23, 2022 in Others by narikkadan
• 63,720 points
2,010 views
0 votes
1 answer

How to show a row in excel if there is a X

FILTER Function: "filters" a range of data ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,720 points
230 views
0 votes
1 answer

How to remove borders from cells in a range in Excel using VB.net?

range.Borders(Excel.XlBordersIndex.xlEdgeLeft).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeRight).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeTop).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeBottom).LineStyle ...READ MORE

Jan 5, 2023 in Others by narikkadan
• 63,720 points
1,428 views
0 votes
1 answer

Multiple columns of excel only shown as 1 column

Data is separated into CSV (Comma Separated ...READ MORE

Jan 29, 2023 in Others by narikkadan
• 63,720 points
384 views
0 votes
1 answer

How do I show the computations after S/N 1048576 in a separate sheet

Add: If xRg.Row = xRg.Parent.Rows.Count Then ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,720 points
290 views
0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

Jan 19, 2023 in Others by narikkadan
• 63,720 points
801 views
0 votes
1 answer

Excel function to dynamically SUM UP data based on matching rows and columns

Excel 365 for MAC should have the BYCOL function, Given: Your ...READ MORE

Jan 21, 2023 in Others by narikkadan
• 63,720 points
707 views