Unable to use the same formula for different rows in excel
RDPD
I am using a Substitute Formula to replace a character '?' with '@'. But the formula isnt working as desired for the other rows when i drag the formula downwards.
The same output gets copied for others rows too. This happens even though the formula for other cells corresponds to its respective cells
.
Please help!!!
DeanOC
Your formula is fine; it works correctly for me.
I can replicate your behaviour by setting the spreadsheet to manual calculation, so my thought is that yours is too.
You can check the setting from the Formula tab on the Ribbon. Click the Calculation Options item to see the current setting.
If it is manual, change to Automatic and your formulae should work as expected.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: how to import 1 flat file to multiple tables in SSIS
- Next: app.yaml cannot call my css file for my index.php
Related
Related Related
- 1
same formula but different result in Matlab and Excel
- 2
Excel if blank cell use different cell in formula
- 3
Excel Hide Rows Formula
- 4
Can I use an Excel formula to calculate the sum of some continuous rows?
- 5
Why is my constructed formula giving different results than the same formula as UDF in Excel?
- 6
Which excel formula to use?
- 7
Use a formula by Group in excel
- 8
Excel average rows to array formula
- 9
Excel formula for selecting "n" rows
- 10
what is different in excel formula start with = and +
- 11
Excel nested formula with different columns
- 12
Excel formula to format different numbers
- 13
Excel formula over full column result is different than with fixed range (same values)
- 14
Using Countifs formula when the data is on different rows
- 15
How to use different colors of texts in same Excel cell using ClosedXML?
- 16
How can I use a formula to match multiple criteria from a different table in Excel?
- 17
Ignoring Hidden Table Rows in Excel Formula
- 18
Create rows from values with Excel formula
- 19
Excel formula/VBA to detect a property of a group of rows
- 20
Excel formula for collapsing adjacent rows with a sum
- 21
Excel - Formula will not skip rows after spreading
- 22
Unable to assign formula to cell range in Excel
- 23
Is it possible to declare a variable within formula and using it into same formula in excel?
- 24
Excel formula: Add entries in same month and year
- 25
Excel Formula to Calculate Percentage on Different Sheet
- 26
Excel formula to subtract a different value based on conditions
- 27
Excel formula gives a different answer when in JavaScript
- 28
Excel formula to Sum 12 rows every 3 rows
- 29
Consolidate data from several worksheets with same columns but different number of rows in Excel
Comments