Forum Widgets
Latest Discussions
फोनपे से पैसे कट गए तो क्या करें?
फोनपे से पैसे काटने पर क्या करें अगर {OO90-38-988-442+/O9038-988+442}से पैसे कट जाएं, तो ये कदम उठाकर पैसे वापस पाए जा सकते हैं ऐप में जाकर " ट्रांजैक्शन" या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें.Solvedvdhd636Nov 08, 2024Occasional Reader1View0likes3Commentsफोनपे से पैसे कट गए तो क्या करें?
फोनपे से पैसे काटने पर क्या करें अगर {OO90-38-988-442+/O9038-988+442}से पैसे कट जाएं, तो ये कदम उठाकर पैसे वापस पाए जा सकते हैं ऐप में जाकर " ट्रांजैक्शन" या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें.Solvedvdhd636Nov 08, 2024Occasional Reader1View0likes3CommentsTrying to Find/Replace Based on Another Sheet in Power Query
I have a list of URLs that have UTF-8 characters in them and I need to replace all of the UTF-8 characters with the actual characters (i.e. %26 to &). I've found two code samples from a separate thread to help me with this but I'm having trouble targeting the correct column (LinkURL) and am getting an error: The two code samples referenced above: // Variant1 ReplacedUtf = Table.ReplaceValue( Source, each [LinkURL], null, (old_value, current_value, replacer) as text => if current_value is null then old_value else List.Accumulate( ListReplacmentsTexts, current_value, (value,lists) => Text.Replace( value , lists{0}, lists{1} ) ), {"LinkURL"} ) // Variant2 ReplacedUtf = Table.ReplaceValue( Source, each if [LinkURL] is null then false else [LinkURL], each List.Accumulate( ListReplacmentsTexts, [LinkURL], (current_value,lists) => Text.Replace( current_value , lists{0}, lists{1} ) ), Replacer.ReplaceText, {"LinkURL"} ) This is the sheet with all of the encoding characters in it that I'm trying to reference: Full code for the AllContentReport as found in the Advanced Editor: Column I am trying to target I've tried switching out LinkURL in the code above to Column19 since the promoted headers step hadn't been executed yet but that didn't work either. Due to the nature of this content, I'm unable to share the workbook that I'm working with and, since it's referencing a connected workbook rather than a sheet found in this workbook, I didn't think creating a dummy data spreadsheet would help here. Any help would be greatly appreciated!renee_crozierNov 08, 2024Copper Contributor40Views0likes9CommentsNeed help with a Tiered Bonus Calculation
HI all, I am trying to create a formula that will return a payout from a table based on goal achievement. For example, if the associate achieves between 100 - 102.99% to goal, they receive a payout of $3,000, if they achieve between 103% and 105.99% to goal, they receive a payout of $3,500, etc.. thanks for your help in advance!7Views0likes2CommentsNeed help with this work project pleaseeeee
Hello, I have a spreadsheet with all my data in rows. Within the rows I have conditional formatting to turn a cell red if there is an error, along with a formula that adds "-NO MATCH" if there is an error which is working fine. However I'm trying to create a column with a formula that will result in "YES" or "NO" if the formula detects a red highlight OR "-NO MATCH" within the row. I've been working on this for what feels like hours and can't solve it, I've tried many different ways. One thing to note, every cell has a formula within it, which I feel may be the problem? I need the cells to stay as a formula and not text. I've tried the following: =IF(B3:HB3="-NO MATCH","YES',"NO") =IF(B3:HB3="FALSE*","YES") =IF(B3:HB3=FALSE,"YES") I can't seem to create a formula that can work within a range of B3:HB3 and each cell having a formula..... PLS HELP!11Views0likes2Commentsफोनपे पर गलत ट्रांजैक्शन होने पर क्या करें?
फोनपे हेल्पलाइन सपोर्ट 6306×643414✓ट्रांज़ैक्शन याइतिहास"सेक्शन में जाकर असफल लेनदेन का चयन करके उस लेनदेन को देख सकते हैं और “वापस लें” या ONLINE “वापस लेने के लिए अनुरोध करें” विकल्प का उपयोग करके पैसे वापस प्राप्त कर सकते हैं।Solvedjalb343Nov 08, 2024Occasional Reader4Views0likes3CommentsAdd Checkbox when New Row is Made
Hi All, I'm trying to find a way to automatically add checkboxes to particular cells when a new row of a table is made (e.g. pressing tab at the end column of a table to make a new row). As far as I'm aware, checkboxes from the Developer tab can be somewhat automatically made by: Drag it to a cell Drag the autofill across to another cell (the bottom right square when clicking on a cell) New checkbox is duplicated onto the new cell However, when making a new row, this does not duplicate without using the above method. Is there a way to do this? Preferably without the need for a click-button macro Thank youAzaxaNov 08, 2024Copper Contributor5.5KViews2likes5CommentsFind and Replace Highlight colour
When I'm using the Find and Replace function and hit find, Excel finds the cell but its very hard to see because of the highlighted colour. Is there a way to change the default colour? Thanks in advance.Solvedmark_murphy_manlukNov 08, 2024Copper Contributor63KViews3likes47CommentsAutomatic table rows based on cell value.
I wonder if there is a function to create a table with number of rows and columns based on data in cells. For example, if I put in a cell that I want 4 rows and 6 columns, a table is automatically generated with 4 rows and 6 columns. Is this possible?JZ1411Nov 08, 2024Occasional Reader21Views0likes3Comments
Resources
Tags
- Excel41,548 Topics
- Formulas and Functions24,046 Topics
- Macros and VBA6,242 Topics
- office 3655,791 Topics
- Excel on Mac2,568 Topics
- BI & Data Analysis2,272 Topics
- Excel for web1,835 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,577 Topics